Viewing 15 posts - 16,411 through 16,425 (of 22,219 total)
Lynn Pettis (10/2/2009)
"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
October 2, 2009 at 7:07 am
rockingadmin (10/2/2009)
is there any way other than file stream in sqlserver 2008 for storing large files suchas 10gb file.
None that I'm aware of. You could create 8 or 10...
"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
October 2, 2009 at 6:27 am
What you have to do is import the data from Profiler into a table (preferably not a production server). Then you clean the ouput, basically removing parameters from the Text...
"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
October 1, 2009 at 9:55 am
peter.lane (10/1/2009)
Sorry for wasting your time. Having done the restore, I was releasing to the developers who were dropping and recreating the stored procedures and then coming to me just...
"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
October 1, 2009 at 9:40 am
You want to use filestream. It puts a sort of lock on the file to ensure database integrity. As long as the record exists in the SQL Server, the file...
"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
October 1, 2009 at 4:59 am
If the users are correctly matched to the logins... I still fall back on the backup is different than you think it is. Assuming the users are correctly in place...
"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
September 30, 2009 at 6:59 pm
You must be using an out of date backup. I've seen users missing on a restore because the login doesn't exist from one server to another or the login &...
"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
September 30, 2009 at 11:55 am
john.arnott (9/29/2009)
Am tempted to reply to the non-question with just:42
But that may be too obscure.
I almost posted that as a response but I thought it might tend to start a...
"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
September 30, 2009 at 5:29 am
bmw110001 (9/29/2009)
it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea
Eliminate the loop?
"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
September 29, 2009 at 1:26 pm
bmw110001 (9/29/2009)
hi Grant FritcheyHave done everthing to solve the issue even moved db from 2005 to 2008 but still the issue persists
Then I guess the core question is, what's the...
"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
September 29, 2009 at 9:00 am
You can simply put the statement RETURN in the IF statement like this:
IF (@a = 0) AND (@b = 0)
BEGIN
RETURN
END
ELSE
BEGIN
SELECT....
END
But, you'd be better off returning a value of some sort,...
"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
September 28, 2009 at 7:25 am
I'm going to pile on a bit and agree with Jeff. When you have views calling views that are joined to views, you will begin to get very poor execution...
"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
September 28, 2009 at 7:16 am
There's no real way to limit access of a given database to memory or cpu on the server. If you have a badly performing database, you'll need to isolate it...
"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
September 28, 2009 at 7:12 am
You need to also pass in the owning schema of the table as @table_owner.
"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
September 28, 2009 at 7:04 am
I'm afraid I don't understand the question. Can you expand on it a bit?
"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
September 28, 2009 at 6:54 am
Viewing 15 posts - 16,411 through 16,425 (of 22,219 total)