Viewing 15 posts - 3,436 through 3,450 (of 5,685 total)
We'd need to see the execution plan, actual by preference, estimated only if you just can't get it to run.
Also, are these databases on different servers/using linked server naming methods?...
April 12, 2011 at 1:46 am
I realize this is 2 years old but since it got necro'd anyway, what is this:
INSERT INTO @TempCycles VALUES ('EOF',3)
End Of Fortnight?
April 12, 2011 at 1:42 am
Deepak, I think we're having a language barrier issue here, but I'll try to respond to each of these pieces as I *think* you intended them. Please re-clarify anything...
April 12, 2011 at 1:25 am
paul.knibbs (4/12/2011)
David Data (4/11/2011)
Er :ermm: ... does anyone remember when this forum was about SQL Server, and this thread about SQL Injection issues? :Whistling:
The article this thread is...
April 12, 2011 at 1:12 am
I'm currently on the dev end of a bad little duel between the dba and dev sides of the house. Acquisitions and the like have forced some of it,...
April 12, 2011 at 1:10 am
deepak.a (4/11/2011)
I want some guide lines reagarding what are the best practices we need follow. When we need to write the Remote query ( in the federated Database Desigin)
We're gonna...
April 11, 2011 at 10:43 pm
sunnymalhotra (4/11/2011)
a
SELECT 'a' --marble
FROM AAA --Stupid car...
WHERE EH! = A
GROUP BY Eeeehhhhh... --Fonzy anyone?
HAVING COUNT( '''eh') >= CanadaOnOneDay
ORDER BY [Aaaaaaaaaahhhhhh... Calgon Take Me Away!]
April 11, 2011 at 3:04 pm
Gianluca Sartori (4/11/2011)
Roy Ernest (4/11/2011)
Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten....
April 11, 2011 at 3:01 pm
Steve Jones - SSC Editor (4/11/2011)
April 11, 2011 at 2:50 pm
Pseudocode since you did provide an example but not consumable sample data (see my sig, first link, if you need help with that):
SELECT
t1.Field,
CallCount
FROM
table AS...
April 11, 2011 at 2:12 pm
😀
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted the...
April 11, 2011 at 2:09 pm
<-- I'd like everyone to meet Henry, a cute little feller with a penchant for petting mice with his tonsils. He's actually rather friendly when his owner doesn't actually...
April 11, 2011 at 1:32 pm
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten. I never could decide if...
April 11, 2011 at 1:27 pm
Steve Jones - SSC Editor (4/11/2011)
April 11, 2011 at 11:38 am
Sorry, running tight on time today or I'd be more explanative of what's going on here.
Go through this code and make sure you understand all the moving parts before this...
April 8, 2011 at 2:11 pm
Viewing 15 posts - 3,436 through 3,450 (of 5,685 total)