Viewing 15 posts - 1 through 15 (of 47 total)
As a contractor who works on government contracts, I would suggest just blaming the contractor for the failings for government projects belies bias on your part and a misunderstanding of...
August 25, 2016 at 7:49 am
I'm late to the game on this and just skimmed the article, but I'm confused why you wouldn't just use Redgate's free sql search tool. That tool is so...
April 10, 2015 at 2:07 pm
I was thinking they should've used a between clause instead of the greater than and less than clauses.
July 29, 2014 at 2:52 pm
Wish I'd known about this 4 years ago!!!!
June 3, 2013 at 9:39 am
Executed exactly as provided you will get the following on SQL Server 2008 R2
Msg 111, Level 15, State 1, Procedure sp1, Line 12
'CREATE/ALTER PROCEDURE' must be the first statement in...
March 1, 2013 at 7:42 am
Grant Fritchey (1/29/2013)
You are two service packs behind.
That's the windows operating system. Not sql server.
SELECT @@version
Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04...
January 29, 2013 at 3:29 pm
Grant Fritchey (1/29/2013)
Brett Phipps (1/29/2013)
January 29, 2013 at 10:27 am
Well, I've finally worked my way through some syntax issues, etc and instituted the changes that Eugene suggested. But unfortunately, it did not solve the issue. In fact,...
January 29, 2013 at 10:24 am
It's SS 2005. 32 bit server with 4gig of ram. He changed the settings to only allow it to use 2 gig of ram. This seems to have resolved the...
January 29, 2013 at 6:28 am
Heh. Nah. I know it's not you. I've already looked at the link you graciously provided.
We had this problem a while ago in production and...
January 28, 2013 at 10:40 am
UGH! Went to test Eugene's suggestion and now the server is giving me the following problem:
Msg 6513, Level 16, State 27, Procedure spGetGLbyAccount, Line 99
Failed to initialize the Common...
January 28, 2013 at 10:16 am
We use this function on several of reports: It's a vb app. It's super duper fast, so I know it's not the issue.
I only have a problem when...
January 28, 2013 at 9:42 am
I'm not sure if I should respond or do as Brandie suggests, but since I've gotten a response here. I'm going to go ahead and post the create for...
January 9, 2013 at 1:30 pm
I've read the article and skimmed through all the comments looking if there was something that talked about how to actually do the cross apply as Jeff suggests, but I...
January 9, 2013 at 11:44 am
I pulled the following code below from the script so I could try to debug my issue. You could use it to build the statements and then just run...
November 26, 2012 at 10:02 am
Viewing 15 posts - 1 through 15 (of 47 total)