Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,380 reads
PracticalSQLDba
Memory configuration in SQL server and break up of memory utilized by SQL server
In this post I would like to explain memory configuration option and memory utilization pattern in SQL server.I have seen...
2012-03-11
3,729 reads
How to log off remote desktop users from a remote machine ?
When you try to log on to a remote server on emergency to perform some task , it may throw an...
2012-03-06
8,209 reads
Resource Governor Configuration
Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...
2012-03-04
4,596 reads
How to setup a task to delete the old backup files or log files from the server ?
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...
2012-02-27
1,423 reads
How to remove new line character from string using SQL ?
In a varchar column some of the entries were showing space in the left side and even after using the...
2012-02-26
9,150 reads
Blogs
What’s New at AWS re:Invent 2025 – Day 1 Highlights
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
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,...
Forums
Adding a Lot of Seconds
Comments posted to this topic are about the item Adding a Lot of Seconds
SQL Server Licensing is Simple
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
Stairway to Azure SQL Hyperscale Level 5: Data Growth and Fast Auto-Grow Mechanism
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Adding a Lot of Seconds
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers