Viewing 15 posts - 4,186 through 4,200 (of 14,953 total)
I have to ask, why bother with this complex method in the first place.
This seems easier:
DECLARE @XML XML = '<rule> <date>1/7/2005 10:12:43 AM</date> <properties> <RuleName>TrainingEnrollmentSave</RuleName> <DebugLevel>3</DebugLevel> <DBName>BNA</DBName> <DBServerName>sa3sql03bv.sa.ito.ceridian.com</DBServerName> <username>005846</username> <CompanyName>bna</CompanyName>...
May 31, 2011 at 2:21 pm
Wayne, even that's a bad idea.
He'll end up having to query metadata for the returned dataset, unless all the tables have identical structures (in which case, why 50 tables, why...
May 31, 2011 at 2:00 pm
jcrawf02 (5/31/2011)
Do Not Resuscitate
We should put that on all the old...
May 31, 2011 at 1:51 pm
Roy Ernest (5/31/2011)
May 31, 2011 at 1:18 pm
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Considering that we haven't defined either length or time units, I say it's PRECISELY that. For...
May 31, 2011 at 12:27 pm
This could be done through calling a .NET CLR trigger, but it's not a good idea. Better bet is, as already mentioned, set up a queue and a job...
May 31, 2011 at 12:25 pm
The Dixie Flatline (5/31/2011)
GSquared (5/31/2011)
Damian Widera-396333 (5/31/2011)
What is the *REAL* question here?What's the meaning of "42"?
That depends on the question, doesn't it?
Yep.
May 31, 2011 at 12:23 pm
Damian Widera-396333 (5/31/2011)
What is the *REAL* question here?
What's the meaning of "42"?
May 31, 2011 at 12:12 pm
SQLRNNR (5/31/2011)
GilaMonster (5/31/2011)
SQLRNNR (5/31/2011)
Craig Farrell (5/28/2011)
I will not smack Syed with a heavy hand...
I will not smack Syed with a heavy hand...
I will not smack...
*mumbles off to another room, still...
May 31, 2011 at 12:11 pm
It will be slow.
There are several better methods of doing this. You'll want to look into Replication, Mirroring, and Log Shipping. Most likely, Replication is what you need.
May 31, 2011 at 12:07 pm
Best tools for that would be any of the ORM tools, like Linq or nHibernate. Don't do it in a proc, you'll just end up with injection vectors all...
May 31, 2011 at 11:37 am
Can you get into the activity monitoring tools in Management Studio and see what SPIDs are doing what? Or open a connection and run sp_who2?
May 31, 2011 at 11:34 am
Yes, there are ways to do that in a query. They are all horrible and will make your query really, really slow, and really, really hard to maintain.
You're much...
May 31, 2011 at 11:31 am
I'm pretty accustomed to 100k row operations taking a few seconds. It depends on how complex it all is, but I would expect some simple aggregation and summing to...
May 31, 2011 at 11:25 am
The maintenance plans that SQL Server Management Studio can build for you DO leave a lot to be desired. They're really useful to a new DBA who isn't sure...
May 31, 2011 at 11:24 am
Viewing 15 posts - 4,186 through 4,200 (of 14,953 total)