Viewing 15 posts - 48,421 through 48,435 (of 49,552 total)
Consider service broker. The triggers just insert messages into the queue. Message delivery (may be the same db) triggers off a async process that goes off and does whatever necessary...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2007 at 1:08 pm
Jeff Moden (9/29/2007)
Like I said, stop trying to decrypt the whole table... encrypt the lookup criteria and do a normal join or WHERE 😉
Won't work with 2005's encryption routines. They're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 30, 2007 at 12:57 pm
Maybe. I picked GMT-2, not SA specifically. Maybe DST is enabled for all zones by default. Hmmm, checking DST has no effect, neither does unchecking it. Very weird.
Isn't a big...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 2:54 pm
Congrats. When's the party? 🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 2:51 pm
Damon Wilson (9/28/2007)Like GilaMonster mentioned, you may get 2 Case Study questions in your pool of 25 (or however many) exam questions. You have the entire 90 or 60...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 7:11 am
iirc, it wasn't a class. Was during supper on friday night. Was a group of 12 or so of us and most of the people at the table were MVPs...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 6:56 am
May I ask what you're trying to do and why you find it necessary to change the system tables? That way lies madness
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 3:32 am
If I may suggest, do your formatting on the front end, not in SQL. VB has far more options for date formats than SQL does and it quite a bit...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 3:26 am
MSDB is a perfect example of how not to design a database. Every time I have to get data from that DB I end up tearing more hair out.
The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 3:17 am
p.s. If you can, go and sit with one of the users who is complaining so that you can see what's happening.
I heard a good story at PASS. One guy...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 3:14 am
Jeff Moden (9/27/2007)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 3:10 am
The agent XPs always change from 1 to 0 as the server starts shutting down. It's an effect, not a cause.
What caused the shutdown is another matter. What's the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 2:57 am
There's an option in the profiler gui that sets whether the duration displays as milliseconds or microseconds. It measures in microseconds regardless, as do some of the performance related DMVs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2007 at 2:51 am
Couple times I had only 2-3 questions on a case study. Is not fun as the time is short. First time I got one of those I hadn't finished reading...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2007 at 2:23 am
May I suggest, once you've got this mess sorted out, considering table partitioning for such a large table? That way you'll have several smaller tables that appear to be a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2007 at 1:49 am
Viewing 15 posts - 48,421 through 48,435 (of 49,552 total)