Viewing 15 posts - 4,666 through 4,680 (of 22,219 total)
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
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.
"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:24 am
Ray K (6/6/2016)
Grant Fritchey (6/5/2016)
Ray K (6/4/2016)
Grant Fritchey (6/4/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 6, 2016 at 4:06 pm
Ray K (6/4/2016)
Grant Fritchey (6/4/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 5, 2016 at 4:03 am
In an hour... you've got almost no time. I'm teaching an introductory course over a lunch next week. I keep thinking of stuff I want to include, but there's just...
"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 4, 2016 at 5:51 am
David Burrows (6/3/2016)
Grant Fritchey (6/3/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 3, 2016 at 6:54 am
Grumpy DBA (6/3/2016)
Grant Fritchey (6/3/2016)
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.
Wait. Client tools are no longer an option to...
"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 3, 2016 at 6:01 am
You can try going into the Tools, Options menu. Once there, scroll down to SQL Server Object Explorer. Select the Scripting option. Then scroll down until you see "Generate script...
"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 3, 2016 at 5:59 am
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.
Wait. Client tools are no longer an option to install with the rest...
"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 3, 2016 at 5:40 am
Viewing 15 posts - 4,666 through 4,680 (of 22,219 total)