2016-08-23 (first published: 2015-05-01)
1,398 reads
2013-04-17 (first published: 2013-04-03)
1,445 reads
2013-03-19 (first published: 2013-03-01)
1,040 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
5,284 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,233 reads
2013-02-06 (first published: 2012-12-27)
1,832 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
923 reads
2012-12-03 (first published: 2012-11-07)
2,009 reads
2012-10-04 (first published: 2012-04-10)
2,007 reads
2012-07-25 (first published: 2012-07-12)
2,488 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Improving the Performance of UPDATE Statements in SQL Server
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Replacing a Null
Comments posted to this topic are about the item Replacing a Null
The End of SQL Server 2019
Comments posted to this topic are about the item The End of SQL Server...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers