How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,619 reads
maintenance
Disk space Notification by Email
As per Threshold value DBA will get notified about the Disk Drive usage.
2007-11-23 (first published: 2007-10-08)
1,663 reads
RE: to cursor or not to cursor
You can view a cursor like something that is based on a select statement. It is this select statement that populates the cursor.So, you may have a table that have some rows physically sorted by a clustered index from, say 1-10. However, to actually see these rows you must get them, and to get them […]
2005-04-12
RE: newbee question aboutTempdb
The use of Tempdb depends on a lot of things: how heavely cursor, sorts, on-the-fly agregations are used, rollups, etc. Also Tempdb is shared with all DB's and users, so as usual, it depends. IMHO this what you can do: set the log file to 500 MB, and set both to autogrow with 100 MB increments. Then […]
2005-04-07
RE: Attach DB and Procedure Cache
When you execute sp_detach_db, the procedure cache is flushed for that database. This is probably due to DBCC DETACHDB() [which sp_detach_db wraps], though this command is undocumented. Edit: You can see this by watching syscacheobjects. I did so with the pubs db on a development sql server. Run a stored procedure, verify it's in the […]
2005-03-31
RE: Curious Locking
Thanks for that..had a look.The execution plans were identical.I tried varying the indexes on this table. One index in particular was dropped and it cured the problem....the query now runs in about 5 minutes instead of an hour. Funny thing is the same indexes exists on a similar test system and that runs ok??Thanks again..Graeme
2005-03-11
RE: Using Litespeed for D.R.?
There should be no issue as the Litespeed doesn't alter what's in teh backup, just compresses it. If you're worried, you can always convert the litespeed backups back to native and perform normal resotres for the system dbs.
2005-02-03
Macromedia breeze
i cant start that program.guess something wrong with MS SQL server.2004-11-26 09:40:15 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2004-11-26 09:40:15 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2780 2004-11-26 09:40:15 - ? [101] SQL Server HERNGYIH version 8.00.760 (0 connection […]
2004-11-28
8 reads
2004-09-06
Multiple Instances
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-06
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