Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,567 reads
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,567 reads
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,470 reads
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
189 reads
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
184 reads
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
522 reads
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
79 reads
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
94 reads
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
248 reads
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
4,964 reads
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
76 reads
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Picture this, you’re happily backing up your database to a Azure blob storage until...
By Steve Jones
I had a customer recently ask if SQL Compare could show them the differences...
hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....
Hello, our users are complaining about blocking during a delete loop so I'm thinking...
Hi, I've got an issue on SSRS where I have a daily subscription that...