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,319 reads
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,724 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,181 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,563 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,393 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,133 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...