Viewing 15 posts - 7,441 through 7,455 (of 8,416 total)
Peso (7/10/2009)
Your TallyNumbers table must begin with 0 (zero).
Sheesh.
*exits*
July 10, 2009 at 7:18 am
July 10, 2009 at 7:14 am
Matija Lah (7/10/2009)
Care to tell us why you're using undocumented DBCC commands?What's the business case behind this requirement?
That's possibly the least helpful reply I have seen today. I mean,...
July 10, 2009 at 7:11 am
GSquared (7/10/2009)
Would "Any" or "All" count? I'm assuming "In" doesn't.
🙁 No, they're not functions. 🙁
Otherwise, I could count SELECT :laugh:
July 10, 2009 at 6:48 am
Peso (7/10/2009)
Something similar to this, if "random" also mean unique.The drawback is that the numbers generated per "batch" are similar, but still unique in the batch.
Adding the missing definition for...
July 10, 2009 at 6:45 am
GilaMonster (2/18/2009)
July 10, 2009 at 5:11 am
Florian Reischl (7/9/2009)
You can use sp_MSForeachdb and a temp table
Note that this only lists user-created tables.
(This may be what is required...but I just thought I'd point it out, for completeness.)
If...
July 10, 2009 at 5:06 am
This is often caused by a concurrent activity such as an offline index rebuild holding a Sch-M (schema modification) lock on a system table.
July 10, 2009 at 4:57 am
Florian Reischl (7/9/2009)
Just out curiosity, why don't you use a linked server or xp_cmdshell to call sqlcmd?
Yes, absolutely. With a linked server, the EXECUTE AT {linked server} syntax is...
July 10, 2009 at 4:53 am
dwaggott (7/9/2009)
July 10, 2009 at 4:29 am
DBCC FREEPROCCACHE and DBCC FREEPROCINDB are both fairly blunt instruments.
To selectively remove just Ad-Hoc plans from cache (leaving the 'good' object plans like triggers and stored procedures) use:
DBCC FREESYSTEMCACHE('SQL Plans')
It...
July 10, 2009 at 4:23 am
Peso (7/10/2009)
July 10, 2009 at 4:03 am
Heh. Ok, so that was the version based on HashBytes using SHA1. My mistake.
The attached plan is a run using CHECKSUM.
This time 175K code existed already, we're still...
July 10, 2009 at 3:59 am
Viewing 15 posts - 7,441 through 7,455 (of 8,416 total)