MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,693 reads
Windows 2008 Server : Moving Cluster Quorum Disk to New SAN
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,478 reads
SQL Server: Measuring The Index Fragmentation
In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....
2012-04-20
11,717 reads
SQL server: Deciphering Wait resource
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
32,381 reads
SQL Server - Index Fragmentation - Understanding Fragmentation
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,336 reads
Caveats of a CONTROL SERVER permission
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,955 reads
Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,953 reads
SQL server 2005 Database Mail stopped functioning after installing Service Pack 3
Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...
2012-03-26
1,252 reads
How do you secure the SQL Server instance after enabling xp_cmdshell ?
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,547 reads
Importing images to SQL server database using T-Sql
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
11,400 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCP Nganjuk | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Ahmad Yani No.282 -284, Payaman, Kec. Nganjuk, Kabupaten Nganjuk, Jawa Timur 64417...
BCA KCP Maluku | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119 @BCA.KCP.Maluku
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers