Viewing 15 posts - 34,756 through 34,770 (of 49,552 total)
Will take a look, but may only be this weekend. Deadlock are a fair bit of work
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 9:16 am
WebTechie38 (1/13/2010)
RESTORE DATABASE [MyData]...
NORECOVERY,
You asked SQL to restore the database and then leave it in the restoring state so that you can restore more backups. That's exactly what NORECOVERY...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 9:10 am
Try this then
SELECT COUNT(Email) AS NumberOfEmails -- get the count
FROM (
SELECT DISTINCT TOP 15 Email -- get 15 unique emails
FROM (
SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 8:56 am
ifila (1/13/2010)
I would like only the TOP 15 unique emails.
Just 15 unique email addresses? No counts involved?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 8:33 am
Move is used to move the mdf and ldf files. What was the exact command that you ran to start the restore? Did you use the NO_RECOVERY option?
Is there...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 8:04 am
SQL can only do an index seek when the where clause references a left-based subset of the index key. In your first query, that's exactly what it's doing, so that's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 7:55 am
SQL choses the appropriate locking level and, unless you really know what you're doing, it's better to let it decide.
Can you post the full script of these two stored procs?
CLAS.dbo.P_delete_pending_request
CLAS.dbo.p_get_Appro_Data_Process
Given...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 7:49 am
Threads can't be deleted. That's why I put the redirection in here and the request for no more replies. Just leave this thread alone and people can answer in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 7:45 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic846818-361-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 6:18 am
Sample data please. Just a few rows that are in the table so we can see what we're dealing with. 3 pages on and I still don't know what you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 6:18 am
Can you post the entire deadlock graph please? There's no enough info in just the resource list.
You've got a classic two-object deadlock there. Processe613ac8 has the keylock (a lock on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 6:12 am
Is google offline again? Is books online not working?
These two, and all of their subpages will tell you just about all the changes.
http://msdn.microsoft.com/en-us/library/cc280407.aspx
http://msdn.microsoft.com/en-us/library/bb500435.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 5:29 am
bbryce (1/13/2010)
Now - can you just do something about the icy cold weather we are getting in Ireland?
Afraid not. I'm still trying to get the weather to confirm to my...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 5:25 am
Henrico Bekker (1/13/2010)
Hi GailSent it to the Members@sql******.co*** address as instructed on the SASSUG site, to subscribe.
Ok, that's looked after by the webmaster, not me. I'm doing manual notifications this...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 1:32 am
Never got any mail. Did you send it via the forum? Can you try a PM?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 12:44 am
Viewing 15 posts - 34,756 through 34,770 (of 49,552 total)