Viewing 15 posts - 2,716 through 2,730 (of 5,394 total)
It doesn't make sense IMHO.
However...
select *
from a
except
select *
from a
where id in (select a_id from b)
It would be much more sensible if you selected id only:
select id
from...
September 15, 2011 at 2:08 am
Ninja's_RGR'us (9/14/2011)
Full backups... I also need to do tlog backups?!?!
Backups???!!???!!
What the hell are backups???
September 14, 2011 at 10:55 am
gsc_dba (9/14/2011)
Depending on the script you wish to run, you could try:
sp_msforeachdbThere are limitations and caveats for sp_msforeachdb to be wary of though...http://www.sqlservercentral.com/Forums/Topic438415-266-1.aspx
September 14, 2011 at 9:50 am
This is my favourite version:
;WITH tenColumns AS (
SELECT 1 A, 2 B, 3 C, 4 D, 5 E, 6 F, 7 G, 8 H, 9 I, 10 J
),
tenRows AS (
SELECT...
September 14, 2011 at 8:30 am
I guess now I'll have to write it 100 times on the blackboard...
It worked with "definitely", so... why not?
country
country
country
country
country
....
😀
September 14, 2011 at 7:48 am
Koen Verbeeck (9/14/2011)
Gianluca Sartori (9/14/2011)
I come from a contry on the edge of bailout, but I still can spell. 😉Hihi 😀
Ouch!:blush:
Ok, I can't!
September 14, 2011 at 7:17 am
Grumpy DBA (9/14/2011)
How come intelligent DBAs cannot spell "definitely"? "defiantly" and "definatly" have been used in this thread...
Uh! You made me rush to check how I spelled it.
I come...
September 14, 2011 at 6:56 am
My bad, I missed that part of your post.
I think the only possible solution is coding a trigger and ROLLBACK changes when a duplicate key is found.
It's not beautiful and...
September 14, 2011 at 5:47 am
You can create an indexed view filtering out NULL values and create a UNIQUE clustered index on the view.
I have done this before and I have to say it works...
September 14, 2011 at 4:27 am
tommyh (9/14/2011)
Gianluca Sartori (9/14/2011)
matt.bowler (9/13/2011)
Not to mention the coolest SSC avatar 🙂Congratulations.
Is there a prize for the cheapest? :w00t:
Yes but you will have to wait for Italy to be forced...
September 14, 2011 at 3:21 am
matt.bowler (9/13/2011)
Not to mention the coolest SSC avatar 🙂Congratulations.
Is there a prize for the cheapest? :w00t:
September 14, 2011 at 1:56 am
ALZDBA (9/14/2011)
We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/
Congratulations Jeff !!
Great news! Congratulations, Jeff!
Well deserved!
September 14, 2011 at 1:31 am
Ninja's_RGR'us (9/13/2011)
Gianluca Sartori (9/13/2011)
If you want a replacement for sp_MSForEachDB, (it appears to have some issues) you can take a look here:http://spaghettidba.wordpress.com/2011/09/09/a-better-sp_msforeachdb/
What issues?
The ugly cursor in there can skip databases...
September 13, 2011 at 8:15 am
If you want a replacement for sp_MSForEachDB, (it appears to have some issues) you can take a look here:
http://spaghettidba.wordpress.com/2011/09/09/a-better-sp_msforeachdb/
September 13, 2011 at 7:00 am
Chad Crawford (9/12/2011)
September 12, 2011 at 2:20 pm
Viewing 15 posts - 2,716 through 2,730 (of 5,394 total)