We have a new author at SQLServerCentral.com, Muthusamy Anantha Kumar AKA The MAK, who starts a new series on the basics that a DBA needs to know. This installment walks over basic backup and restore.
2008-07-15
13,180 reads
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,305 reads
2009-05-26 (first published: 2008-07-09)
838 reads
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
11,315 reads
2008-08-27 (first published: 2008-07-03)
2,189 reads
2008-07-02
5,331 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
22,987 reads
2008-06-25
4,174 reads
2008-06-24
4,224 reads
I was troubleshooting an issue last week on a vendor-developed database when they stated we needed to look at each one of the 50 tables in their database to make sure that all fields expecting default values, had default values assigned.
2008-06-11
3,561 reads
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers