Viewing 15 posts - 17,896 through 17,910 (of 22,220 total)
If you don't have windows authentication enabled anywhere, then you might be in trouble. There's no way to hack past the password (even if there was, this is not 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
March 28, 2009 at 6:12 am
I don't quite get the question either. If you read the foreign key constraint, it's going to tell you which table is constraining. From there you can either simply select...
"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 28, 2009 at 6:11 am
Whatever this job is, I hope it's not too intrusive to the system since it sounds like it's going to be running 24/7. If you're inserting or updating data all...
"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 28, 2009 at 6:09 am
Jeff Moden (3/27/2009)
How about the uplifting and ever popular [font="Arial Black"]"RBAR - Death by SQL" [/font] 😀
I don't know. That sounds... almost... on topic. :hehe:
"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 27, 2009 at 6:54 pm
Kendal Van Dyke (3/27/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
March 27, 2009 at 6:38 pm
You can create clustered and nonclustered indexes on temp tables.
Syntax is like this:
CREATE INDEX myindexname ON schemaname.tablename(col1,col2)
INCLUDE (col3)
WITH FILLFACTOR=80
ON Primary
That creates an index consisting of two columns which includes...
"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 27, 2009 at 1:30 pm
NO!
Never run the Profiler gui against Production.
It uses a completely different mechanism for gathering the data to present from what the server-side trace uses. This mechanism can, and will,...
"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 27, 2009 at 1:08 pm
Roy Ernest (3/27/2009)
Grant Fritchey (3/27/2009)
You can get them from the client.
On which client? Normal Web App that uses the Sproc?
I meant the data access layer, regardless of how it's displayed....
"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 27, 2009 at 9:41 am
suhasini.m (3/27/2009)
I am running both the quries at the same time and also doing DBCC DROPCLEANBUFFER and DBCC CLEARPROCCACHE before for both the queries.
If this is...
"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 27, 2009 at 9:40 am
It really depends on what you need to do. Let's assume a row into each table. You create a proc with variables for each of the columns, except the two...
"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 27, 2009 at 9:35 am
CTRL+2 in a query runs sp_who by default. You can change that.
It sounds like you were hitting CTRL+2 to open a table? I've never seen that done before. If you...
"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 27, 2009 at 9:29 am
They add to the overhead. I use them occasionally when debugging, but always comment them out.
However, I've never tested them to see what the exact cost is.
You can get...
"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 27, 2009 at 9:22 am
Jeff should do it.
"Pork Chops for the DBA" by Jeff Moden
"SQL Server Performance Tuning by Pork Choping Deveopers" by Jeff Moden
"Better Performance by True Set Based Operations and Pork Chops"...
"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 27, 2009 at 8:43 am
suhasini.m (3/27/2009)
SELECT * FROM Table1
JOIN Table2
ON Table1.Column1 = Table2.Column1
SELECT * FROM Table1
JOIN Table2
ON Table1.Column1 = Table2.Column1
AND Table1.Column2 = XXX
Both these query returns same number of results say...
"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 27, 2009 at 8:38 am
Yes, they are very handy, aren't they?
"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 27, 2009 at 6:32 am
Viewing 15 posts - 17,896 through 17,910 (of 22,220 total)