Viewing 15 posts - 1,216 through 1,230 (of 1,583 total)
Anyone?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2012 at 1:33 pm
Can you post the DDL for your tables...Also, is there any particular reason you have a seperate table for each year? Why not have all the data in one...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2012 at 9:59 am
Sounds like you're using the Idera SQL diagnostic manager 😉
Have you been able to view the Deadlock graph? I believe it's "Show Deadlock View" - you have two different...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2012 at 8:44 am
Not sure if anyone else experienced this issue, however, I'd like to share my experience:
I modified the code a fair amount but kept the "core" portion of it in tact...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 9, 2012 at 10:19 am
Can you please post/attach your query execution plan?
It is my understanding (others than correct my ignorance if needed) that an indexed view is just that, it's "indexed", the entire view...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2012 at 1:54 pm
I've not actually used it before, but have read some articles on using the Resource Governor - could you not try using that to restrict memory usage/cpu/etc by application?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 6, 2012 at 1:17 pm
Laymens terms (from the articles listed above):
sp_executesql has the same behavior as EXECUTE with regard to batches, the scope of names, and database context. The Transact-SQL statement or batch in...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 2, 2012 at 9:19 am
Check your inbox, I've sent you the code needed and the basic instructions on how to set it up (shouldn't take more than a few minutes) - Good luck!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 2, 2012 at 8:37 am
I'll send you something tomorrow that might be useful...currently OOO
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 31, 2012 at 2:23 pm
Aren't they removing named pipes entirely from the next version of MSSQL?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2012 at 10:44 am
Create an RDL file (Reporting Services Report), set up multiple datasources (to the servers you want this to run on), then you can use the following query to get basic...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 30, 2012 at 8:24 am
Yikes it's one of those days :w00t: I'm going to have a glass of water to wash down my foot!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2012 at 9:51 am
How busy is the server during the time of failure? If there's a lot of connections, I/O or CPU utilization going on, I've seen (many times) that specific driver...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2012 at 8:50 am
I stand corrected 😀
Lowell, I love your example however, there's one small error in your code, it errors out at the SELECT:---Can clarkKent see the table he...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2012 at 8:26 am
I would reccommend checking your Agent job (LS_RESTORExxxx) and see if you can track down when the errors began, it should tell you which TRN file started causing the problem,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 27, 2012 at 7:25 am
Viewing 15 posts - 1,216 through 1,230 (of 1,583 total)