DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.
2008-03-18 (first published: 2007-04-23)
17,608 reads
That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.
2008-03-18
4,114 reads
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-18
26 reads
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-18
32 reads
Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.
2008-03-18
2,894 reads
How you use dynamic SQL, when you should - and when you should not.
2008-03-18
6,537 reads
2008-03-17
7,697 reads
SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events.
2008-03-17 (first published: 2007-07-04)
15,800 reads
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-17
32 reads
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-17
29 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
I recently used accounting assignment help, and it made a huge difference in my...
Comments posted to this topic are about the item This Week's AI Trust Problem...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers