Viewing 15 posts - 16 through 30 (of 71 total)
Maybe I am misreading your table, but shouldn't 'AADR' return 'AADR', 'AAIT', and 'AACC'? It looks like 'AACC' also belongs to the Financial Sector.
May 28, 2012 at 11:00 pm
Have you read through the SQL Server 2008 Upgrade Technical Reference Guide?
This includes multiple strategies for your upgrade as well as other utilities which can be used in addition to...
May 27, 2012 at 12:14 am
Also, just in the spirit of enhancing productivity, consider downloading SSMS Tools Pack (http://www.ssmstoolspack.com/) from Mladen Prajdic. It's a phenomenal product and it's free.
May 24, 2012 at 11:28 pm
I have also seen this behavior. One of the things I've noticed is that if you run a query against the trace file (something like SELECT * FROM fn_trace_can't_remember_syntax), it...
May 24, 2012 at 10:30 pm
Have you considered loading the trace file into a table and then deleting the rows which contain the backup execution statements? Well, I guess you'd have to delete both the...
May 24, 2012 at 10:21 pm
The database at my current job has 1600 stored procedures, 200 views, and 140 functions. With those kind of numbers, SSMS becomes a time sink as you scroll and scroll...
May 24, 2012 at 10:07 pm
At first I thought you might be getting an error message from having a nested EXEC in your stored procedure:
Msg 8164, Level 16, State 1, Procedure p_Test, Line 5...
May 24, 2012 at 12:28 am
This question has turned into an excellent learning experience for me. I took the opportunity to run the new queries against Paul White's optimized schema on both my laptop and...
September 17, 2010 at 1:35 pm
Thanks everyone for your help. To create a baseline, I've attached a script to load sample data (takes about 2 minutes if you're interested). I also attached the sqlplan for...
September 16, 2010 at 11:46 am
Thanks for looking at this. I tried removing the extra column but didn't see any substantial difference in the elapsed time of the query.
Although I did notice that upon...
September 15, 2010 at 9:22 pm
To everyone, thanks for all your input.
This is my first experience implementing an enterprise system and so I didn't even know that things like system clocks exist (although it seems...
August 24, 2010 at 10:14 am
This is great information. Thanks for taking the time to provide such a detailed explanation (and for catching the bugs in the code...). The majority of responses I've received when...
July 17, 2010 at 2:43 pm
Thanks for both of your responses. Very informative for me...
July 9, 2010 at 10:44 am
Thanks for your response...can I ask a follow-up question? (and maybe this is more philosophical than technical, but I'm curious to hear your thoughts)
You refer to this method as poor...
July 6, 2010 at 9:43 am
This is great. Thanks again for your help!
July 3, 2010 at 11:07 am
Viewing 15 posts - 16 through 30 (of 71 total)