sql-lover (8/23/2013)

---

I am sorry to disagree... but for a SAN with actual mdf and ldf files there, I see no reason to defrag, specially if we are talking about TBs...

Since NTFS still fragments the file - which has nothing to do with how that file is laid out on a SAN - you should still look at the fragmentation...

What is the recovery model of the database? If it is full recovery, how often are you running transaction log backups? Are you shrinking the log files at...

I would check out the NUMA nodes and make sure you haven't over-allocated the memory in such a way that it is causing issues.

Microsoft removed the Open Table option - it is now replaced by the Select Top xxxx/Edit Top xxxx.

Once SQL Server lost connection to that drive - it doesn't check again. You can try taking the database offline and bringing it back online, but you may actually...

DoubleEx (9/2/2011)

---

Sorry - I forgot to post the message. I sanatized the message replacing the DB name with MyDatabase and the Domain as MyDomain and the server as MyServer.

The...

Jeff Moden (8/7/2013)

---

That would also make for a bit slower code, IIRC. Without 2 part naming, it searchs for the object using the current user schema. If it...

Sean Lange (8/5/2013)

---

It will run and it will be successful no matter what time it...

Correct - however, it is rather wasteful...

Here is what I use

Use {your database here};

Go

With partitionStats (object_id, rows, reserved, data, used)

...

FYI - on VMWare 4.1 (and higher) you can now setup and specify the number of cores and logical processors per core. This is very useful when you need...

asita (7/9/2013)

---

Hello All,

thank you for your inputs, i appreciate your help,

unluckly i dont have any audit/log enabled

now onwards, how can i make it auditable (with out my dba interfere), what...

Not sure if this will perform any better - but is another way of generating your tally table and a calendar.

Declare @date1 date = '20130101'

...

You can either use the extract utility - which will convert the litespeed backup file into native files. However, the files will no longer be compressed and it could...