SQL Server 2008 R2 - The list of the supported features
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions...
2010-03-24
1,223 reads
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions...
2010-03-24
1,223 reads
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-24
4,013 reads
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,475 reads
A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).
SQL Server 2008...
2010-03-21
1,237 reads
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-20
2,790 reads
Since the early versions of SQL Server, from version 6.5 we can know and
determine the latest version that we...
2010-03-20
1,055 reads
SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
The content of this update includes 11 Presentations, 17...
2010-03-06
611 reads
There it is the SQL Server Migration Assistant or SSMS for MySQL, it comes for both versions SQL Server 2008...
2010-02-20
1,843 reads
This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.
SQL...
2010-02-19
644 reads
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,123 reads
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers