Using a date or int column as the clustered index.
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on...
2014-12-08 (first published: 2014-12-01)
6,986 reads
Blog Posts
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or articles - if you have anything that you think...
2014-12-07
5 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
44 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
88 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the setup files.
The BITS service is used to download files...
2014-12-07
3 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...
2014-12-07
50 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...
2014-12-07
53 reads
2014-12-07
1,053 reads
SQL Server – Ports used by Database Engine and other SQL Features
Most of us know the default port for SQL Server is 1433, but there are various ports being used by SQL Server...
2014-12-07
366 reads
How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75
When you do SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER...
2014-12-06
333 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers