Viewing 15 posts - 5,011 through 5,025 (of 9,722 total)
And are you sure no changes, like password changes, were made to the service account?
December 15, 2011 at 10:10 am
I forgot to add... Have you looked at using Service Broker for your needs?
December 15, 2011 at 10:09 am
Why would you put your CLUSTERED index on the ID field of the table? You're not searching by ID, presumably, but by date or another field. You can do a...
December 15, 2011 at 10:08 am
Google "SQL Server Editions" without the quotes plus whichever SQL Server version (2008, 2008 R2, 2012) you want to see.
December 15, 2011 at 10:04 am
Dev (12/15/2011)
Symptom of cross post:SSC refreshes the page while posting.
Workaround:
Browser's back button & hit Post. 😉
Not quite. If you don't refresh the page, you'll have the same problem....
December 15, 2011 at 9:20 am
Stefan Krzywicki (12/15/2011)
Koen Verbeeck (12/15/2011)
Back on topic again:http://www.sqlservercentral.com/Forums/Topic1222173-391-1.aspx
And it's with our personal favorite: the interview questions!
I especially like his replies. We're all fake (and not crazy?).
I do like that he...
December 15, 2011 at 9:18 am
Dev (12/15/2011)
there are at about 7 types of SQL Server DBAs in the world
Would you please share it here or give a pointer to the article.
Here's an...
December 15, 2011 at 8:05 am
Back on topic...
sqldba2k8, if you want to learn SQL Server, grab Books Online, grab a How-To book (I used Sybex Certification books back in the day), get yourself a cheap...
December 15, 2011 at 7:38 am
That is good information, Jon. Thanks for the link!
EDIT: Although, this issue probably is something that needs reported to Microsoft to see if they'll fix it.
December 15, 2011 at 7:29 am
Personally, I like to grab chocolate when things break. It makes life so much more pleasant to eat chocolate while the world is falling apart around me. @=)
December 15, 2011 at 6:47 am
Lowell (12/15/2011)
i tried switching to LOWER as Brandie identified, and i get a function that never finishes executing...
That's what I'm running into. I'm not quite sure why it's doing that.
EDIT:...
December 15, 2011 at 6:22 am
I've been testing further and it turns out it's the setting of the result to the variable that's causing the issue.
Try this:
DECLARE @result as numeric(38,9),@ftest as numeric(38,8), @ResultNonConvert as numeric(38,8),...
December 15, 2011 at 6:10 am
Is there a reason why the second line uses UPPER() instead of LOWER()?
I'm trying to test this just using the code inside the function and it is taking a damn...
December 15, 2011 at 6:05 am
Wow. I have just replicated this behavior using your code.
Hmm. What version SQL Server are you using?
EDIT: In further testing, it's not the function that is the problem. Try this...
December 15, 2011 at 5:44 am
As I have said in many of my SQL Saturday presentations, Books Online is your best friend. Learn it, Live it, Love it.
December 15, 2011 at 5:41 am
Viewing 15 posts - 5,011 through 5,025 (of 9,722 total)