Viewing 15 posts - 4,666 through 4,680 (of 22,227 total)
You'll have to set up an Azure account too. If you have access to MSDN, you can get a free account with a limited amount of funds for each month....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 6:37 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 15, 2016 at 7:37 am
subramanian.esakkimuthu 40485 (6/14/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2016 at 4:29 am
Viewing 15 posts - 4,666 through 4,680 (of 22,227 total)