Viewing 15 posts - 31 through 45 (of 205 total)
Thanks for the reply. I cannot get the archival query to execute at this time because it can never get a memory grant from SQL Server, so I cannot check...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 23, 2017 at 8:04 am
1. The server is Enterprise Edition. I would love to give the server more RAM, but people other than the DBA's dictate how much RAM the servers get and we...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 23, 2017 at 5:56 am
A reboot overnight seems to have cured the problem.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 7, 2015 at 6:09 am
Have you tried installing SQL 2005 on your box? I have 2005, 2008, and 2012 version of SQL Server and BIDS installed on mine. I know I installed 2005 after...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 6, 2015 at 7:45 am
If you have to limit TempDB due to space constraints, you gotta do what you gotta do. This will result in failures on the app side if it cannot use...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 8, 2014 at 12:58 pm
OK, here are three. I had to change the extension to upload them. SSC does not allow XDL files.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 6, 2014 at 5:23 am
I am not familiar with what a deadlock graph looks like, so I'm kind of in the dark here. I looked at that article and what is described as a...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 3, 2014 at 1:14 pm
Here are three images. Is this what you need?
Jeff,
I am reviewing your suggestions and trying to implement them today.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 3, 2014 at 5:22 am
Jeff,
In a perfect world this never would have happened. In my world, ruled by management, I can only be as heavy-handed as they will allow me. My first suggestion was...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 2, 2014 at 2:03 pm
And if you do determine that a procedure is probably not used, you would be wise to rename that procedure for a period of time rather than delete it. This...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 2, 2014 at 6:20 am
Yes, your post did say that. In my case though, I found the other yesterday and didn't get back to this post until this morning. Either way, thanks.
If you would...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 4, 2013 at 9:09 am
ScottPletcher, yes, AuditLogID is the clustered Index and an Identity column. I am always interested in better, faster ways to make things happen, if I can maintain data integrity.
I have...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 4, 2013 at 7:36 am
Where I need the better performance is in my archival process. I have to work around the inserts from Biztalk, to log to three different tables, at a rate of...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
December 3, 2013 at 5:47 am
After meeting with some of the principals we are looking at improving the query and view designs. I generated an execution plan for the query/view and found the largest, ugliest...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 7, 2013 at 12:53 pm
Gee, and you guys haven't even seen the underlying view this query is acting on. :w00t: I don't ever think I have seen a more complicated execution plan than what's...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 7, 2013 at 7:06 am
Viewing 15 posts - 31 through 45 (of 205 total)