Tagged Questions
2
votes
2answers
78 views
Can I see the RAID group name for my SQL Server Database files?
Is it possible to see the RAID group name that my database (and log) files are sitting on, in one of the DMVs (or some other system table) ?
3
votes
1answer
183 views
Query to check where database growth was?
I have a database that grew very significantly overnight and I'd like to find out why. I've restored yesterdays backup to another location. Is there a query I can run to query the size of tables or ...
2
votes
1answer
204 views
Creating the database on different file groups
What is the pros and cons of creating the database for a operational system on different file groups? I know it is useful if you want to keep the static part of a database online when the other part ...
4
votes
1answer
169 views
Adding SPARSE made table much bigger
I have a generic log table, about 5m rows.
There's a "strongly typed" field that stores event type, and a bunch of "losely typed" columns that contain data relevant to the event. That is, meaning of ...
5
votes
2answers
149 views
Database placement on abstract storage structure
Often times we all hear the same thing. The recommendations on where to put OLAP/OLTP databases, where to put the tempdb, where to put transaction logs...etc.
But say you are in an environment where ...
3
votes
2answers
301 views
Windows Storage Server, SQL Server, regular files — means to protect from insider threats?
This is my first post here, and I am by no means qualified as a Windows Server or Storage Server 2008 or SQL Server 2008 administrator. I am mostly a Unix guy, however tasked with a job to investigate ...
3
votes
1answer
124 views
SQL Filegroup degrading performance
On our dev boxes, our database resides entirely in the PRIMARY filegroup, and everything works fine.
On one of our production servers, recently upgraded from 2005 to 2008, we noticed it was ...
