How do I clear the procedure cache? dbcc freeproccache (undocumented) - Removes all elements from the procedure cache. dbcc dropcleanbuffers - removes all the clean buffers from the buffer pool. You can also stop and start SQL Server to achieve the same results. I wanted to know how often one should do this and how […]
2001-12-20
4 reads
How to find out in a month how many time friday or sunday count as well as if i want to print the last friday of the month then how to do please suggest
2001-12-20
2 reads
Hi: I'm new to SQL/T-SQL. Migrating an Access application. I've scanned/read a few books but haven't found the information I'm looking for. I have a simple task to pre-process the contents of a table. It looks at ALL records in the table (usually 50 or so records, 200 would probably be a high water mark). […]
2001-12-20
2 reads
Comments posted to this topic are about the content posted at http://support.microsoft.com/servicedesks/webcasts/wc120401/wcblurb120401.asp
2001-12-16
3 reads
Comments posted to this topic are about the content posted at http://support.microsoft.com/servicedesks/webcasts/wc120401/wcblurb120401.asp
2001-12-16
2 reads
I noticed in SQL BOL for v7.0 that you need to rerun setup when renaming a server. We are using a product call Octopus which is a replication and takeover product that allows us to mirror two seperate servers, eg S1 and S2. S1 is the online server and S2 the backup. If S1 fails […]
2001-12-10
1 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/MFagerlund/datastandards.asp
2001-12-09
7 reads
I'm getting message: Server: Msg 514, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to communicate with debugger on CASQL1 (Error = 0x80070005). Debugging disabled for connection 62. Any idea what does it mean and how can I fix it in order to debug stored procedure...
2001-12-06
How would you restore the master database in a MS Cluster Environment if your master db has been corrupted.
2001-11-28
4 reads
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers