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,219 reads
SQL Tact
Find Dependencies
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
..This operation must be performed in the master database."
"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,055 reads
Actual Emails: Is "NOLOCK is the epitome of evil?"
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,868 reads
View execution plan for a sproc in the wild
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,693 reads
Open_transaction_count in sys.dm_exec_sessions
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,383 reads
Using sys.dm_exec_requests to find a blocking chain
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,147 reads
Slides and Sample code: SQL Server Admin Best Practices with DMV's from the Houston TechFest 2011
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
921 reads
Resource Governor clamps down on Greedy Reports
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
Houston TechFest UG Leadership Summit
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
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Multiple Collations
Comments posted to this topic are about the item Multiple Collations
Retrieving Data Using the REST API in Data API Builder
Comments posted to this topic are about the item Retrieving Data Using the REST...
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers