Next Gen File System ReFS(Resilient File System) and SQLServer !
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...
2012-12-13
1,105 reads
anup.varier@gmail.com
- Website: http://sqlsailor.com
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,457 reads
PASS Summit 2012 News – Check- in Experience!
Registration and Check in for PASS Summit 2012 was opened yesterday (Nov 4th), and I decided to utilize this opportunity...
2012-11-05
789 reads
PASS Summit 2012 Countdown Begins !!!
All roads lead to Seattle!
If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...
2012-10-23
1,206 reads
Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,282 reads
Backing up the “log” of a database which is in Simple recovery model ! – Watch out for this!
In theory we cannot backup the log of a database which is in Simple recovery model, however there is a...
2012-10-01
1,090 reads
Cannot assign a default value to a local variable !
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,925 reads
Max Text Replication Size – When you might have to care about this number !
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,895 reads
You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...
2012-09-13
736 reads
Installing SQLServer for SCCM 2012 – Some points to note on patch levels
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,683 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
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers