Table Space revised Again
Since I am in the Collation Sensitive mood, I am finally getting around to updating this script. This is the Table Space script that I have had out there...
2011-11-17
3 reads
Since I am in the Collation Sensitive mood, I am finally getting around to updating this script. This is the Table Space script that I have had out there...
2011-11-17
3 reads
This is a continuation of my DBA in Space journal.
Friday, September 16, 2011
OMG. (This is the first time in my...
2011-11-16
607 reads
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
4,937 reads
One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...
2011-11-16
474 reads
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...
2011-11-16
1,273 reads
Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...
2011-11-16
1,042 reads
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-16
12,893 reads
Home Sweet Cubicle
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave...
2011-11-16
595 reads
I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....
2011-11-16
544 reads
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The...
2011-11-16
587 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers