Date Range
Date Range
Date Range
Created to simplify your daily database related tasks. Turn any data into a SQL Table. Quickly! Remember the days you had to struggle trying to import external content into your SQL Server? These days are now over! Read data from any source - HTML, Excel, Word, PDF, Text and much more and turn the data into a SQL Table - in a split second! SQL Server Query Zipper.
Live, Learn, Share. Getting and storing a high precision datetime. Earlier today I was working on a project where I was recording some time stamps. Database Master Keys can have more than one password.
Free offer for Microsoft MVPs. Testing was conducted independently by VeriTest, a testing service of Lionbridge Technologies.
The 2014 Swedish SQL Server usergroup challenge. Sunday came early this week. For windowed functions, SQL Server introduces two new operators in the execution plan; Segment. Two or more SCD tables, while keeping all the versions information intact. Sound tricky? Parallel execution, part 3.
Use NOT IN operator carefully. Whenever you use NOT IN operator you will have to be more conscious. Following example will explain why we need to be careful while using NOT IN operator. 0 rows will be returned when you execute the above statements. And this not the correct answer. This is because ultimately NOT IN operator is equivalent to.
Rudy Panigas - Blog on Microsoft SQL Server. About Me - Who is DR DBA? View my complete profile. Wednesday, April 22, 2015. Not working on a server. First check if the following is in place.