Removing Identical Duplicate Rows
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,201 reads
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,201 reads
Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause has a number...
2012-02-21
1,034 reads
"Cannot alter a server audit from a user database. This operation must be performed in the master database."
If you're trying...
2012-02-03
1,024 reads
Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,
Can you send me references to support my contention that NOLOCK...
2012-01-24 (first published: 2012-01-21)
3,865 reads
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,375 reads
Got stored procedure problems? I feel sorry for you son.
Here's a quick query to pull the cached execution plan out...
2011-12-16
1,690 reads
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,143 reads
Here's my official blog page for my presentation on SQL Server Admin Best Practices with DMV's from the Houston TechFest...
2011-10-15
920 reads
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,297 reads
At the Houston TechFest 2011 Conference at the University of Houston I will be hosting a User Group Leadership Summit...
2011-10-06
572 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers