sys.dm_exec_query_stats will give you stats of various queries that have been run since last recycle or cache cleanup.

sys.dm_exec_qery_plan will give you execution plan of queries. THis is a function and...

jsauni (10/10/2011)

---

I usually set the database to single user before the restore and back to multi after the restore has been done. That usually obtains an exclusive lock/access to the...

select name,type,

sum(single_pages_kb+multi_pages_kb) as MemoryKB

from sys.dm_os_memory_clerks

group by name,type

order by memorykb desc

http://msdn.microsoft.com/en-us/library/ms191304.aspx%5B/url%5D

You can directly backup a database to tape, however generally database backup is taken on disk and then the disk backup is copied to tape.

isuckatsql (10/9/2011)

---

select LTrim(RTrim(FirstName)) As Ian FROM @tblCity2 where ProfileId = @ProfileId

Gives me the result below, and truncates the last phone number digit.

' 615-661-457'

If i change the FirstName to a...

select * from sys.indexes where fill_factor<>0 -- assumption - default fill factor is 0

I have assumed the default fill_factor setting has not been checked. Run the below code to check...

hah. i saw the forum which is SQL Server 2008 🙂 Forgot op is using SQL Server 2000 while replying!

do the vendor needs to access the financial data? if not, you can scramble key columns in the database(customer details, account numbers etc), then take a backup and send to...

I guess the vbscript file is called using cscript.exe via a batch file(guess!!). You can use xp_cmdshell to execute the batch file.

It might not be enabled on your system. check...

You can try taking compressed backup and see the backup size. However, as said, the problem is of network. Get that fixed and get the network pipe size increased.

check if you have a default database set for this login ID.

You should leave your database to a size you think is sufficient to grow for may be a year or 6 months or so.

Having said that, If you have got...

Did you use the script mentioned in the link provided by Ninja's_RGR'us?

At times, it takes more time to roll back/roll forward transactions copied from the log file in the backup file. It'll finish on...

dbdmora (10/3/2011)

---

What is the best way to spread the data among all the files or a quicker way for SQL to fill up the rest of the NDF files. ...