Viewing 15 posts - 5,881 through 5,895 (of 7,164 total)
Jeff Moden (6/24/2011)
opc.three (6/24/2011)
Be careful with table variables. They always optimize with an assumed rowcount of 1 so can produce very bad execution plans...even with small actual rowcounts.
A statement level...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 3:22 pm
Is this synchronous or asynchronous mirroring?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 2:02 pm
denis.p (6/24/2011)
There are two tables - Lines and Heads, and there are two triggers - one for each table.
Both are defined as "after-"...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 1:54 pm
S_Kumar_S (6/24/2011)
...But still want to be sure that my procs and functions dont break when we change the level.
Wow, I hope you're not asking for people that have no idea...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 1:34 pm
Tough spot. It sounds like you know enough T-SQL to get it going, but yeah, 2,000+ lines of procedural T-SQL code is what you get when you do stuff like...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 1:07 pm
denis.p (6/22/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 12:57 pm
Eric M Russell (6/24/2011)
Jeff Moden (6/24/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 11:22 am
Jeff Moden (6/24/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 11:18 am
Not sure if I understand cmopletely because you have three names floating around: DBNEW, DBSQL and DBOLD\SQL. How I read the post is that you want requests that were going...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 11:04 am
This one looks like homework. I agree with Sean that things like this should be left to the presentation layer. That said, if this is homework or your hands are...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 10:40 am
jarid.lawson (6/23/2011)
CELKO (6/22/2011)
Why do you want to do this in SQL? It was never meant for writing parsers. And you got some data element names wrong.
I don't get a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 10:19 am
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an object...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 9:24 am
You're very welcome 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 7:53 am
Gee Craig, I don't know what to say, except wow! I got pulled into an SSIS mess yesterday afternoon so did not have time to do any testing. Even if...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 4:47 am
No problem. I am curious now though, because a default of 100 is not really appropriate for most shops IMO...I usually change the default to 90 on all my systems...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 24, 2011 at 4:24 am
Viewing 15 posts - 5,881 through 5,895 (of 7,164 total)