Viewing 15 posts - 18,571 through 18,585 (of 22,226 total)
So it's two different databases? You can join the tables together in a query by referrencing the database name, but you can't create a foreign key across databases.
"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
January 30, 2009 at 3:55 am
You must be new in this galaxy.
"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
January 29, 2009 at 9:12 pm
Bruce W Cassidy (1/29/2009)
Greg Edwards (1/29/2009)
I'd say that depends on if you got the correct results.:w00t:
[font="Verdana"]Yup. I added a cross join as well. And the full outer joins...
"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
January 29, 2009 at 9:02 pm
Jack Corbett (1/29/2009)
My question is, was 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
January 29, 2009 at 8:59 pm
GilaMonster (1/29/2009)
Bruce W Cassidy (1/29/2009)
sometimes it's fun having a good ol' mud-slinging match with someone who is absolutely sure they are right. And sometimes that's even me!
We...
"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
January 29, 2009 at 8:57 pm
Jean-François Bergeron (1/29/2009)
CAST(MfrCode AS NVARCHAR(max)) LIKE 'tel%' AND
CAST(VendorCode AS NVARCHAR(max))...
"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
January 29, 2009 at 1:45 pm
Jean-François Bergeron (1/29/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
January 29, 2009 at 1:05 pm
I've been a DBA, exclusively, for about 10 years now and no certification whatsoever. You just don't need one. Knowledge and experience are what really counts. If you have three...
"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
January 29, 2009 at 12:56 pm
Since the functions seem well in hand, I'll address other stuff.
You're using CONVERT on your columns in the WHERE clause. This will absolutely prevent the indexes, if any from being...
"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
January 29, 2009 at 12:01 pm
It sounds like you're locking the resource and then blocking all others, not like a deadlock. Leave the deadlock monitors in place, but you should take a look at 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
January 29, 2009 at 11:50 am
The thing is, MAXDOP is a way to limit paralellism. A lot of times, in the OLTP type systems I work in, parallel queries cost more than they provide benefit....
"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
January 29, 2009 at 8:24 am
Why do you want to mess with MAXDOP? Your default setting is 0, which means that SQL SErver will use as many processors as it has available to it. Maybe...
"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
January 29, 2009 at 7:45 am
Take a look at the information availabe on SQL Server Agent in the Books Online. You can do exactly what you want through there.
"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
January 29, 2009 at 7:41 am
As far as "when" to create a clustered or nonclustered index, I'd strongly suggest creating the cluster first, then the noncluster. Since a clustered index key defines the storage for...
"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
January 29, 2009 at 7:37 am
My absolute favorite is Embarcadero ERSTudio. Fantastic set of functionality.
CA offers another that's extremely popular ERWin. There are a couple of others available, but those are the two big ones.
"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
January 29, 2009 at 7:32 am
Viewing 15 posts - 18,571 through 18,585 (of 22,226 total)