Keeping track of the space used and free in your database files is something that all experienced DBAs need to do. And something many new DBAs forget. New author Jayakumar Krishnan brings us an easy technique to do this in SQL Server 2008 with Policy Based Management.
2009-12-16
8,535 reads
BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.
2009-12-16
2,465 reads
The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...
2009-12-16
2,636 reads
Provides Stored Procedures and SSRS Report to show job status with details of errors.
2009-12-15
9,573 reads
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-15
4,053 reads
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,522 reads
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,815 reads
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,779 reads
Explains how to convert a list of Ids passed as string and convert it to a table
2009-12-14
14,184 reads
A new direction in BI, with a new flagship interface for Business Intelligence from Microsoft. Steve Jones talks a little about the back story he heard from Microsoft.
2009-12-14
1,839 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers