Viewing 15 posts - 15,736 through 15,750 (of 22,219 total)
I think Jason was kidding on that one. But hey, the more posts with my book in them, the better.
😀
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2010 at 6:42 am
Yes, a SELECT statement places a shared lock on the table, not an exclusive lock.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2010 at 6:23 am
And when you make the query into a procedure as Paul says, make the parameters NOT NULL and the users will have to supply them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2010 at 6:21 am
Another vote for Books Online. I have it open on my desktop all day, every day.
But, sometimes, on some topics, BOL can be structured funny, so having access to other...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2010 at 6:11 am
You say "restore" but did you run a command BACKUP DATABASE and a command RESTORE DATABASE or did you use some sort of migration routine or the Copy Database wizard?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2010 at 6:06 am
Joy Smith San (3/12/2010)
I've found that when I had to use linked servers, OPENQUERY provided much faster results.
It's amazing..! Open query is too fast...to be precise, it fetches data...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 12, 2010 at 5:53 am
GSquared (3/11/2010)
CirquedeSQLeil (3/11/2010)
GSquared (3/11/2010)
As promised a couple of months ago, I've updated to having a beard in my pic. 🙂Holy Crap - who is that?
That's me with 2 months...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 12:40 pm
Congrats Jeff!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 12:37 pm
Closed circle then, because I'm reading this stuff to try to understand what I might be seeing in the future.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 9:23 am
It sounds like, possibly, the app is holding the transaction open. If you close the window the connection and the wait clears... pretty good indicator.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 7:47 am
Alberto.Omini (3/11/2010)
I have a problem between Access and Sql2005.
I use a linked table inside temporary access mdb.
Client have sqlexpress insalled (two version : one is 9.0.053 and the other...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 7:37 am
Sleeping or running doesn't indicate whether or not a query needs tuning. You need to pick a methodology of monitoring that will inform you of where the problems lie. I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 7:33 am
The wait state suggests that your process is waiting either on traffic on the network or the client software is not taking the results quickly enough.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 7:30 am
Joy Smith San (3/11/2010)
[/Quote]
I had asked this question before also...
Inorder to use OPENQUERY, Do we need to make the linked server using...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 7:13 am
The question isn't whether or not putting more memory on the box will speed up the query. The question is whether or not your query is running slow because of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 11, 2010 at 6:43 am
Viewing 15 posts - 15,736 through 15,750 (of 22,219 total)