SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a...
2011-11-14
539 reads
SQL RNNR
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a red-eye trip from Salt Lake to New York. The...
2011-11-14
3 reads
T-SQL Tuesday #024: Prox ‘n’ Funx
I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches. Fortunately...
2011-11-08
662 reads
T-SQL Tuesday #024: Prox ‘n’ Funx
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can...
2011-11-08
5 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time...
2011-11-07
575 reads
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time will warp on us. The Las Vegas user group...
2011-11-07
4 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time...
2011-11-07
674 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time to jump back in the deep end. If you...
2011-11-07
4 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,265 reads
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
4 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers