RE: Performance trouble
Any other applications run in this server too? If they are, check which applications are the cause of paging.
2003-04-25
Disaster Recovery (DR)
RE: Performance trouble
The disks configuration is the same than the old server. The OS resides on a 9 gb RAID 0, and the DB files on a 60 Gb RAID 5.
2003-04-25
RE: Return Recordset From SP w/Parameters
First create a AdoCommandObject for the stored procedure. Create the parameters for SP. Set the values to parameters Use adoCommandObject.Execute method to get the recordset.
2003-04-25
RE: Getting the SUM of length
Hi, with a small correction in the typo convert(decimal(10,2), sum(d.length)/1000)) as length that should work to display the range try a WHERE field BETWEEN <low> AND <high> or WHERE field > <low> AND field < <high> Cheers, Frank
2003-04-25
RE: backup of master database
Only for restoring master database, you must start sql server with sqlservr.exe -m, then you can do the restore. Robert
2003-04-24
RE: Integrity check failing
I'm not suggesting it, but if you did want to go down this route, you could more easily run "Alter database single_user with rollback immediate". Paul Ibison Paul.Ibison@blueyonder.co.uk
2003-04-24
RE: No Job History Entries
Look at the properties of SQL Agent. Has a place where you set the limit for jobhistory, clear existing history. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-04-24
2003-04-24
RE: Result Set to String
FYI I Just ran the query (cut and paste from the forum - no changes) on our Server (SQL2K with SP3) and the results are fine. (3 row(s) affected) We sell Seafood, Produce, Meat/Poultry,
2003-04-23
2003-04-23
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers