Viewing 15 posts - 18,196 through 18,210 (of 22,202 total)
CROSS APPLY works. I've even seen it increase performance. Have you looked at the execution plans? Are those inline or multi-statement UDF's?
February 24, 2009 at 1:09 pm
We use a method similar to GSquared except we have a fourth machine, staging. So we testin QA and then test the deployment in Staging.
Yeah, you could experience data loss...
February 24, 2009 at 9:18 am
Yeah GSquared has it nailed. Nothing in there should be running slow from a pure code structure stand-point. It's likely some other cause. Have you run a server-side trace to...
February 24, 2009 at 9:14 am
Are you seeing errors in the SQL Server logs? Do you have an error number or severity on the client? There are a lot reasons for a disconnect. Without more...
February 24, 2009 at 9:09 am
Ninja's_RGR'us (2/24/2009)
For the first time I had to declare e-mail bankruptcy... just delete everything and move on.
can anybody resume the last day's comments in...
February 24, 2009 at 8:04 am
Like I said, it's not online. It was published in the print magazine SQL Server Standard, which is published by SQL PASS. They don't have the articles on line. Go...
February 24, 2009 at 6:25 am
Yeah Steve, give us more stuff!
OK, maybe just for George here for having a bit more wit than others.
February 24, 2009 at 6:22 am
To really answer the question, we'd need to see the query, but tempdb is used when you create temporary tables, either table variables or old fashioned temp tables, when you...
February 24, 2009 at 5:50 am
1) Without an index, I suspect both queries will result in a table scan. You would want an index there. With an index, I've generally found TOP to work better...
February 24, 2009 at 5:48 am
Temporary tables can be dropped automatically as the process that created them leaves scope (the user logs off or breaks the connection). Global temp tables are dropped automatically when all...
February 24, 2009 at 5:33 am
Yeah, it sounds like duplicate entries and you don't have a natural key defined on the database. That is one of the problems with using an Identity only PK method....
February 23, 2009 at 6:43 pm
Bruce W Cassidy (2/23/2009)
GilaMonster (2/23/2009)
Maybe the blatant feminism. MZB's not subtle about that when she...
February 23, 2009 at 6:32 pm
Bob Hovious (2/23/2009)
She Who Must Be Obeyed
You either read H. Rider Haggard or Rumpole....
Gail, yes the Illuminatus Trilogy is worth reading, although written in the early seventies and geared towards...
February 23, 2009 at 6:30 pm
Bruce W Cassidy (2/23/2009)
GilaMonster (2/23/2009)
Odd, because I normally love Arthurian myth.
[font="Verdana"]After Mary Stewart (brilliant), I find most Atrhurian myth disappointing.
But on the note of dissapointing movies from books and Arthurian...
February 23, 2009 at 1:20 pm
GilaMonster (2/23/2009)
Grant Fritchey (2/23/2009)
I tried three times to read Mists of Avalon. I got a few pages further each time before flinging the book across the room.
I got about half...
February 23, 2009 at 1:16 pm
Viewing 15 posts - 18,196 through 18,210 (of 22,202 total)