Duluth, GA
+ 678-753-4494
contact@datahills.us

DELETE and UPDATE using multiple table joins

  • Posted by Sqltimes
  • On April 13, 2013
  • 0 Comments
DELETE and UPDATE are one of the most powerful statements in SQL. Being responsible for production systems, a lot of times I need to make changes to data (or meta data) in production directly. Any not every system has a development environment where I could test my SQL statements. Scary !! but sadly true. So […]
Read More
 

Adding new data file takes a long time or create database takes a long time. Welcome to Database File Initialization

  • Posted by Sqltimes
  • On April 12, 2013
  • 0 Comments
Update on 9/3/2013:  Added a continuation of this post here for Instance Database File Initialization. Welcome to the world of Database File Initialization. It’s a wonderful concept. Its not something you’ll encounter every day, but when you do, you can see it in action (or perceived inaction) every single time . Database File Initialization: Let’s set the stage […]
Read More
 

Forcing COLLATION in WHERE clause

  • Posted by Sqltimes
  • On April 10, 2013
  • 0 Comments
An interesting titbit, that I encountered today is with COLLATION with in Sql Server. As we all know collation is an important and interesting element in data storage and retrieval. It directly affects the way character data is stored, sorted and inturn retrieved. By default Sql Server collation is set to SQL_Latin1_General_CP1_CI_AS (Latin, case insensitive and accent […]
Read More
 

Error when adding a new file to filegroup: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed

  • Posted by Sqltimes
  • On April 10, 2013
  • 0 Comments
Recently, I encountered an interesting error message. For a database, we needed to add a new file to existing filegroup to help alleviate storage limitation of allocated subsystem. but as I ran the following script, I got the following error. [sourcecode language=”sql”] ALTER DATABASE [DBName] ADD FILE ( NAME = ‘StopGap_Primary.ndf’ , FILENAME = ‘T:\SQLData\Data\StopGap_Primary.ndf’ […]
Read More