Date Range
Date Range
Date Range
Keep your databases in sync with our high speed database comparison tool. Let us help you maximize productivity and control costs with SQL Server 2008. We can help you build and deploy more secure, scalable, and reliable enterprise applications. We can help you build dynamic Windows, Web, and mobile solutions and obtain faster results.
Wednesday, January 17, 2007. MS SQL - Using DateTime as Date to compare dates. To compare 2 dates in SQL - convert them to date first.
Monday, January 22, 2007. Compare Data Using The Command Line Utility. The SQL Studio Data Compare command line interface helps to automate database comparison and synchronization. It allows pre-configured data compare and synchronization jobs to be scheduled and executed at off-times. The command line interface can use saved projects or to create projects on the fly.
Tangra, Inc.
Plamen Ratchev
9334 Cypress Shores Lane
Jacksonville, Florida, 32257
United States
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.
Project Hosting for Open Source Software. Microsoft SQL Server Profiler XML Trace Converters. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. This project aims to provide tools to process the XML trace files generated by the Microsoft SQL Server Profilers into other standard formats so that other applications can make use of the trace data.
A while ago, I published a post about a new challenge. When was DBCC CHECKDB last run? June 16, 2015. Who wants to be a DBA? This i.