How to delete records in all tables in a single database
Hello all, I would like to know how one could delete all records/data in all tables in a single database. thanks, Ram
2004-08-10
json
Question of the Day for 20 Aug 2004
Comments posted to this topic are about the Question of the Day for 20 Aug 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=319.
2004-07-27
Index sizes
Hi everyone, I want to find the list and size of the top 10 indexes in a database. Does anyone have a query that I can use? Thank you!
2004-07-20
Master DB Location Inconsistent
I wanted to move the location of the Master DB, so I followed Microsoft Note http://support.microsoft.com/default.aspx?kbid=224071.As referenced in the note, I set the -d startup parameter to the desired location. Everything is working OK. Enterprise Manager shows the correct location, but when I run the following query it shows the old location.select name, filename from sysdatabases […]
2004-04-09
RE: KILL not working
Is this backup process created by maintenance wizard? If it was, go to server task manager, find the sqlmaint.exe and kill it.
2003-12-15
7 reads
RE: Recovering after Log drive fails
Can you please tell me how this works in detail? I am thinking that if you have a full database backup and some log backups and your log drives goes down with every log entry after your last log backup, then it is not possible to recover the database to the last commited transaction and […]
2003-08-12
RE: SQL query help
In that case can you post the table definition and some sample data in that format and is there a maximum number of 'Comp' values?
2003-08-07
RE: Server Upgrade / Migration
Yep again, I attempted a single user mode restore and it went belly up because it didn't like the fact that the user database weren't where they were expected. The server refused to start so I decided to back out of that strategy. I actually posted the same comments to the Microsoft partner newsgroups and […]
2003-06-25
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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