Viewing 15 posts - 4,651 through 4,665 (of 22,211 total)
CASE statement in the GROUP BY clause is also going to lead to some pretty poor choices by the optimizer.
If you have two different sets of logic, rather than try...
June 27, 2016 at 2:52 am
I absolutely hear you. I've been working with 2016 for quite some time now. I just haven't hit major issues. Not like with other releases. I'm not about to argue...
June 27, 2016 at 1:40 am
You know I don't argue with you. I haven't seen this. Do you have an example, just to educate me.
June 25, 2016 at 4:14 pm
Brandie Tarvin (6/22/2016)
Well, speaking from the perspective of a science fiction fan...The sooner we all get ourselves a world government, the better.
Ha!
Being a different kind of science fiction fan,...
June 22, 2016 at 8:31 am
jasona.work (6/21/2016)
Geez, where the heck has the year gone?We're just under 2 weeks out from the half-way mark of the year...
And I'm only at 56,000 miles so far.
June 21, 2016 at 7:16 am
The two most important things are to start running SQL Server backups of all your databases and, test those backups by occasionally running a restore (to a test system, or...
June 17, 2016 at 7:34 am
djj (6/16/2016)
I had the privilege of meeting Grant last night at the local PASS meeting. Liked his talk. Gave me a few (many) things to check today.
WHOOP!
It was...
June 16, 2016 at 7:24 am
You're cross posting on your own cross post. Please, all responses on this thread, not the other one.
The easiest way to start to combine two queries is to treat each...
June 15, 2016 at 7:37 am
subramanian.esakkimuthu 40485 (6/14/2016)
June 14, 2016 at 9:47 am
ChrisM@Work (6/13/2016)
Y.B. (6/13/2016)
IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)
UPDATE SomeTable SET SomeText = @SomeText
ELSE
INSERT INTO SomeTable VALUES (@ID, @SomeText)
EDIT: Although...
June 13, 2016 at 8:02 am
BrainDonor (6/13/2016)
SQL Saturday Manchester, on July 23rd - who (apart from Hugo) will be going?
No joy for me there.
I am touring user groups in Ohio this week. Cleveland today. Toledo...
June 13, 2016 at 6:44 am
Talib123 (6/13/2016)
Are you considering installing an instance on a PRODUCTION SQL Server?[/quote
Exactly. We don't want to do this. Instead, install a copy of SQL...
June 13, 2016 at 6:14 am
Which city in Germany? I've been over there and spoke at six different user groups. Every one was a great group of people, but each one was a little different...
June 13, 2016 at 4:31 am
Speaking as someone who stopped using the GUI tools for most operations many years ago, I miss the stuff that Azure does not do well because I don't use the...
June 13, 2016 at 4:29 am
For testing purposes, I'd suggest you restore to a different SQL Server instance other than your production instance. Make mistakes elsewhere. You don't want to screw up production.
June 13, 2016 at 4:24 am
Viewing 15 posts - 4,651 through 4,665 (of 22,211 total)