Viewing 15 posts - 9,466 through 9,480 (of 59,078 total)
The words that strike me here is ...
I have a good job, but have been offered one from a company i once worked for
The first step is to sit down...
April 14, 2019 at 4:28 pm
Hi I came across a scenario where a query is picking totally unrelated index in the execution plan. Here is the case: SELECT A.tranid,A.transittime FROM table1 A WITH(nolock) JOIN...
April 14, 2019 at 3:54 pm
Thanks for the feedback folks.
To be honest, I should rewrite the whole, very old article. Using MONTH (which returns on 1-12 regardless of year) or anything else that doesn't observe...
April 14, 2019 at 3:31 pm
Sorry to use 4 words all at once but Sunday, Pool, Beer, and Drambui!!! :D:D:D
April 12, 2019 at 11:20 pm
Is it a good practice to mix some surrogate and natural keys...?
Heh... look at sys.objects for an answer to that question. Both the object_id and the name must be...
April 12, 2019 at 6:39 pm
Hi, I'm very new to this program and have question...In which or what type of scenario I need to built Store Procedure with output parameters in real life job...
April 12, 2019 at 6:17 pm
What I want to know is why people give supposed "design purists" so much credit.
April 12, 2019 at 6:12 pm
I usually don't drink at all because, if I drank every time I ran into some form of stupidity when it comes to code or common sense, I'd be permanently...
April 12, 2019 at 6:08 pm
Personally, I wouldn't do this through T-SQL. I'd use Powershell. Here's an example.
And then scream as the Network folks draw and quarter you for screwing up internal security.
Lordy,...
April 12, 2019 at 6:01 pm
And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process...
April 10, 2019 at 11:49 pm
Some of this is the result of the times we are in. We all know the pressure of release and fix it later competing with if everything gets fixed...
April 10, 2019 at 10:45 pm
When I came back to work Monday I was initially excited to see we were on the new version of SSC. My excitement quickly faded. I read Steve's...
April 10, 2019 at 4:29 pm
True dat! I have seen many time where it will choose a more narrow index to scan (much more quickly) even when it's the second column being used for criteria. ...
April 9, 2019 at 12:30 am
Bad habit of (*) perhaps. Thinking "It's just a count"
Crud... that's what I get for reading a post prior to a quart of coffee. When I first read your...
April 8, 2019 at 6:21 pm
It's not just the missing articles... The "Resources" section on articles (the place where code was attached) still appears to be missing. Especially for articles where the code displayed in...
April 8, 2019 at 2:50 pm
Viewing 15 posts - 9,466 through 9,480 (of 59,078 total)