Archives for SQL Server, Denali - Page 4
SQL Server – Applying Database Tuning Advisor Recommendations
Once you have obtained a good ‘performance’ trace for your database, you can enlist the help of SQL Server’s tuning advisor. The advisor will treat the queries in the trace…
A useful sql server (production) trace template
Introduction To run a sql server profiler session, you need a ‘trace template’. The default built-in templates are a good starting point (especially the ‘tuning’ template). However, a more advanced…
Is SQL Server’s locking overly pessimistic (and what to do about it)?
Introduction For a while now, the production database that is part of my current project, has been throwing SQL Server deadlock exceptions. Deadlocks are usually caused by resource contention –…
Mirroring versus Replication
Both replication and mirroring are methods of transferring data from a primary database to a secondary database. However, they both serve different purposes – and are used in completely different…
Quick deadlock inspection in SQL Server
Introduction Deadlocks occur when multiple processes (usually two) are trying to access the same resource. Sql Server decides – after a specified period of time – to terminate one of…
SqlGeometry Data Type–Treating it alongside other SqlParameters
SqlGeometry is a spatial data type introduced in SQL Server 2008 (R2). It can be found in the namespace. This is a special data type and not one of the…
Moving from Oracle to SQL Server – Data Types To Worry About
As you start planning the migration of the schema objects, one immediate concern will be the data type mismatches between SQLServer and Oracle. Here are some helpful links in determining…
Detaching, Dropping SQL Server Databases–Some gotchas
There’s a couple of different ways to drop/detach databases from sql server (assuming the obvious Right Click, Delete option in Management Studio did not work for you) Method 1 -…
sa user unable to attach detach databases
PROBLEM With a new SQLServer install, if you selected Mixed Mode authentication, chances are you want to be able to use your sa user to connect to the database. You…