Almost made me really thank God for an easy Friday question, only to find that the question and the answer are based on two completely different data types! 🙁

Talking of Dating...I do 😉

Seriously, our product does use ODBC date literals, and hence this one was an...

Gopinath Srirangan (4/5/2011)

---

......

3. Without having primary key or unique key just create unique clustered or non clustered index.

Below code still gives the same result without defining primary or unique key.

So...

martin catherall (4/5/2011)

---

Great question.

One thing that I'd add is that as the unique key will be created as a non-clustered index where as the default for a primary key is...

The fact that the actual test was to demonstrate that a FOREIGN KEY does not necessarily have to reference a PRIMARY KEY, and can also reference a UNIQUE KEY -...

The SQL Server Configuration Manager will help you get rid of the alias.

As far as pointing out code issues, yes, Profiler is one of the tools that you would use....

What edition of Windows 7 is this? (Home Basic/Home Premium/Professional/Ultimate)

IO latches mean hardware - Your I/O subsystem, i.e. the disk is not responding fast enough which means that the SQL Server is spending more time waiting for the data...

No wonder you cannot find DB1 as a separate server - both DB1 and DB2 are aliases of each other!

As far as the need for more memory is concerned -...

Balaji,

1. There is no such thing as "no transaction log" - all operations are logged - it's just that whether or not you want it to be minimally logged, bulk-logged...

willtwc (3/22/2011)

---

Did a test in renaming the sa account. After renaming the account, I immediately run a test sql job which ended ok.

However a little while later (which is...

Database mirrroring is a good option and alternate for replication. You may choose the SAFETY option, which will cause synchronous mirroring (and transactions on Primary will not be committed unless...

balaji.ganga 68339 (4/4/2011)

---

Hi

I want to find out the sqlserver instance ip address.

if i run the ping command using instance name and its shows "could not find the...

Is DB1 a mirror of DB2? Go into SSMS -> connect to DB1 & 2, navigate out to Server Objects->Endpoints->Mirroring endpoints.

The other possibility is that you have log shipping configured,...

APP_SQL (4/3/2011)

---

First of all, great article and very insightful so thanks for taking the time to write it. I do have one question about the approach you explained for deleting...