SQL Server Archives - Page 193 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Creating All New Database with Full Recovery Model

June 1, 2011

Sometimes, complex problems have very simple solutions. Let us see the following email which I received recently. “Hi Pinal, In our system when we create new database, by default, they are all created with the Simple Recovery Model. We have to manually change the recovery model after we create the…

SQLAuthority News – Best SQLAuthority Posts of May

May 31, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Month of May is always interesting and full of enthusiasm. Lots of good articles shared and lots of enthusiast communication on technology. This month we had 140 Character Cartoon Challenge Winner. We also had interesting conversation on what kind of lock WITH NOLOCK takes on objects as well. A quick…

SQL Azure – SQL Azure Throttling and Decoding Reason Codes

May 29, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Azure

I was recently reading on the subject SQL Azure Throttling and Decoding Reason Codes and end up reading the article over here. What I really liked is the explanation of the subject with Graphic. I have never seen any better explanation of this subject. I really liked this diagram. However,…

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

May 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Backup and Restore, SQL Server

SQL Server has a feature which copy database from one database to another database and it can be automated as well using SSIS.

SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON

May 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I was recently watching a videos online of TechEd 2011 USA (link) and I learned that SET FMTONLY ON is going to be replaced with enhanced DMVs in future versions of SQL Server. I really liked the new direction of the product. However, SET FMTONLY ON is really have done…

SQLAuthority News – Most Valuable Photographer – Vijay Raj

May 25, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database

A good snapshot stops a moment from running away. ~Eudora Welty If I could tell the story in words, I wouldn’t need to lug around a camera. ~Lewis Hine Vijay Raj is a passionate Technology Evangelist and a Microsoft MVP. He recently took few snaps of my daughter. As soon…

SQL SERVER – Running SSIS Package in Scheduled Job

May 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Utility

I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.