Partitioning Relational Data – (Part – 1)
A common requirement for dealing with large datasets is the ability to split the data into smaller blocks to help...
2013-01-08
1,015 reads
Blog Posts
Show Only Specific Databases
One of our customers is implementing a very large consolidation project in which they enable users to create their own...
2013-01-08
305 reads
SQL Saturday Fargo Update
It’s been a while since I mentioned anything about the SQL Saturday in Fargo. So I thought I would let...
2013-01-08
578 reads
SQLAgent Job related reports and out of box real time job monitoring tool !
Lets start New Year with a very simple yet useful topic.
I am a big fan of out of box reporting...
2013-01-08
1,254 reads
Step Up and Take More Ownership
This post is part of the T-SQL Tuesday Meme, this month hosted by Jason Brimhall. His chosen theme, to come up with...
2013-01-08
1,557 reads
T-SQL Tuesday #38 - Standing Firm
I often get hung up in the whirlwind of life,
and one of the things that seems to slip my schedule,...
2013-01-08
1,835 reads
T-SQL Tuesday #38 – Standing Firm
This month’s T-SQL Tuesday is hosted by Jason Brimhall. Being as this is January, lots of people are making New...
2013-01-08
756 reads
T-SQL Tuesday #38 – Standing Firm
It’s T-SQL Time again, and this time it’s #38, from Jason Brimhall (b | t | li). The topic this month is...
2013-01-08
1,190 reads
What port is my instance listening on?
I just had the interesting task of finding the port number that one of the instances I deal with is...
2013-01-08
1,699 reads
XML schema (XSD)
When creating XML documents, you must work from a design that defines the structure of the document. This strengthens the...
2013-01-08
989 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