RE: to improve performance?
Follow the execution plan for your queries and check to see if they are using indexes or table scans. This can also give you a clear idea if you have the right columns indexed. Patrick
2003-05-15
upgrading
RE: select and lock next key value
Or create the table as suggested and use an SP to get the next value and replace for the next caller to keep the sequence up. Ex. CREATE PROCEDURE ip_NextKeyVal @val int OUTPUT AS SET NOCOUNT ON UPDATE tbl_NextKeyVal SET @val = col_KeyVal = col_KeyVal + 1 GO Handles locking and value quite nicely.
2003-05-08
Declaring Cursors error
With the line of code: DECLARE MyCursor CURSOR SCROLL DYNAMIC FOR SELECT.... I'm getting a error message: the variable MyCursor does not currently have a cursor allocated to it. Can anyone help? DavidFC
2001-11-26
189 reads
Database dump/ tape backup scheduling
Scheduling of database backups: In the past I dumped our databases to a local folder at 9pm and backed the folder up to tape. Due to a shrinking time window our Sys Admins are kicking the Tape jobs off at 6pm. I have no control over when the job backs-up a given server. If the […]
2001-11-23
2 reads
Master / msdb Log Questions
1. In a default SQL 7 install what database is associated with the "distmdl.mdf" and "distmdl.ldf" files? 2. The master database has components: master.mdf and mastlog.ldf. But in practice I have never been able to dump the "trans log" for the master databases. Does this mean that I can only restore the master database from […]
2001-11-23
4 reads
Does Not Delete Expired Backup Files
I am having a problem with SQL Server 7.0 no sp not deleting expired backup files on a Windows NT 4.0 sp6a enviornment. I see this is a problem for the 95,98,ME platforms but can not find any information for NT. Does anyone have any ideas? Thanks for the help, Kat
2001-11-23
2 reads
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