Viewing 15 posts - 6,946 through 6,960 (of 15,381 total)
Yet another copy of the same thread. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1491239-7-1.aspx
September 4, 2013 at 7:22 am
pwalter83 (9/4/2013)
Sean Lange (9/3/2013)
September 4, 2013 at 7:13 am
brian.cook (9/3/2013)
Thank you for the suggestion. Max is only three digits for it. If I start running into issues, I will add the value you suggest.
Why not just add the...
September 3, 2013 at 11:57 am
You seem to have forgotten the ddl. Even if the tables were provided it really isn't very clear what you are trying to do here. Can you try to explain...
September 3, 2013 at 10:41 am
It only happens after 6:30pm? Do you have other applications running at that time? Do you have login triggers? I take it that at other times of the day everything...
September 3, 2013 at 8:19 am
duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1490970-391-1.aspx
September 3, 2013 at 8:18 am
Great job posting ddl and sample data. However your description is very unclear. Can you post what you expect as output and try again at explaining the logic?
September 3, 2013 at 7:39 am
erikd (9/2/2013)
Wait, what's the non-default and presumably non-crappy Intellisense?
And now a message from our sponsor....RedGate has a product called SQL Prompt. I think may be a few others out there...
September 3, 2013 at 7:16 am
And now a word from our sponsor (Molap). It seems your thread has been hijacked by a discussion well outside the bounds of your original question. As has been said...
August 30, 2013 at 2:24 pm
ScottPletcher (8/30/2013)
Sean Lange (8/30/2013)
ScottPletcher (8/30/2013)
Sean Lange (8/30/2013)
ScottPletcher (8/30/2013)
Sean Lange (8/30/2013)
NOLOCK hints. They are NOT a performance boost.
To me, that's not a logical claim. While NOLOCK is clearly dangerous, it...
August 30, 2013 at 2:16 pm
ScottPletcher (8/30/2013)
NOLOCK can be useful, for example, for code lookup tables, such as state code lookups. A state hasn't been added since 1959, I think I'll risk it :-).
And...
August 30, 2013 at 2:07 pm
ScottPletcher (8/30/2013)
Sean Lange (8/30/2013)
ScottPletcher (8/30/2013)
Sean Lange (8/30/2013)
NOLOCK hints. They are NOT a performance boost.
To me, that's not a logical claim. While NOLOCK is clearly dangerous, it DOES in fact...
August 30, 2013 at 1:56 pm
adonetok (8/30/2013)
SQL server administrator want me to...
August 30, 2013 at 1:53 pm
Viewing 15 posts - 6,946 through 6,960 (of 15,381 total)