How easy it is to check which statements consuming most of the CPU & RAM–TIP #68
Problem:- One of the most important question comes in our mind what is the cause of slow SQL SERVER.
We...
2014-11-01
259 reads
Rajat Jaiswal-337252
How to take Transaction Log backup ? TIP# 68
As we discussed in earlier tips how to take full backup and differential backup now in this tip we will...
2014-10-30
894 reads
How to take differential backup ? TIP #67
Friends,
We were discussing backup from last few post. Now lets take a look one more feature of backup which is...
2014-10-28
521 reads
Oh! I forgot When I took last Database Backup ? How to determine this? TIP # 66
In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...
2014-10-25
286 reads
Blogs
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers