Utility Queries–Database Files, (and Filegroups)

Posted by drsql on SQL Blog See other posts from SQL Blog or by drsql
Published on Mon, 02 Jul 2012 02:33:32 GMT Indexed on 2012/07/02 9:20 UTC
Read the original article Hit count: 260

Filed under:

Catalog Objects

|

Development

|

Tips

|

t-sql

|

utility

It has been a while since I last posted a utility query, and today, to avoid other work I am supposed to be doing, I decided to go ahead and work on another post. Today, I went ahead and worked on a server configuration type query. One query I find I use pretty often is the following one that lists the files in the database. In this blog I will include 3 queries. The first will deal with files and databases, and the second runs in a database to see the files and their filegroups (If there...(read more)

© SQL Blog or respective owner

Related posts about Catalog Objects

Looking under the hood of SSRS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
SSRS is a powerful tool, but there is very little available to measure it’s performance or view the SSRS execution log or catalog in detail. Here are a few simple queries that will give you insight to the system that you never had before. ACTIVE REPORTS: Have you ever seen your SQL Server… >>> More
Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
Ancillary Objects: Separate Debug ELF Files For Solaris

as seen on Oracle Blogs - Search for 'Oracle Blogs'
We introduced a new object ELF object type in Solaris 11 Update 1 called the Ancillary Object. This posting describes them, using material originally written during their development, the PSARC arc case, and the Solaris Linker and Libraries Manual. ELF objects contain allocable sections,… >>> More
android app does not show up on my device or the emulator in eclipse

as seen on Stack Overflow - Search for 'Stack Overflow'
hey everyone, I have no errors in my app-code what so ever, but when i try to run in on either my cell or my emulator/the avd in eclipse i can't run it because it doesn't show up on either one. this is my console output: [2011-02-04 08:14:58 - Versuch] Uploading Versuch.apk onto device 'CB511L2WTB' [2011-02-04… >>> More
How to mix C++ Qt objects and Qt Jambi objects

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to combine some existing Qt code written in C++ with some code written in Java using Qt Jambi, but I'm not quite sure how to do it. I'm basically trying to acieve two things: Pass a QObject from C++ to Java using JNI Pass a Qt Jambi QObject from Java to C++ It looks like I can… >>> More

Related posts about Development

How to resolve: 'cmd' is not recognized as an internal or external command?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched other forums to solve this error where it would either end with: 1.) re-install OS 2.) Setting path variable C:/Windows/System32 The latter did not work, and as you can probably imagine, I do not want to have to re-install my OS... I am running the command "mvn jetty:run" and the… >>> More
PHP Web Development, Web Development Using PHP As an Open Source

as seen on Ezine Articles - Search for 'Ezine Articles'
PHP is a widely-used general-purpose scripting language that is especially suited for web development and can be embedded into HTML. PHP is the most famous language nowadays as it is an open source and web development requires no costs in implementation. >>> More
Small Business Web Site Development - 3 Tips For Getting Business Web Development

as seen on Ezine Articles - Search for 'Ezine Articles'
If your want to grow your Small Business, Web Site Development is a crucial ingredient for this new growth going forward. Web development is more than putting words or content on a web page. Today more than 50% of folks looking for products or services use the internet to find what they needs. Here… >>> More
Surface development: it’s just like software development

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Surface is magic. Everyone using it seems to think that way. And I have to be honest, after working for almost 2 years with the platform I still get that special feeling the moment I turn on the unit to do some more work. The whole user experience, the rich environment of the SDK, the touch, even… >>> More
Desktop development versus Web development

as seen on Stack Overflow - Search for 'Stack Overflow'
What are the advantages and disadvantages of one model and the other? Why and when would you choose one or the other? If you were going to build a business application, which is the best approach for you? To make this a fair question, is better if you post only quantified non-subjective answers. >>> More