Viewing 15 posts - 4,216 through 4,230 (of 22,224 total)
Ad Hoc:
SELECT * FROM Table;
If this is run from SQL Server Management Studio, Reporting Services, Integration Services, or through code from an app, it's ad hoc because it's not in...
"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
November 18, 2016 at 1:02 pm
For the second time this year, I successfully got a Linux VM running with SQL Server on it. Last time I just did the install & walked away. This time...
"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
November 18, 2016 at 10:40 am
jasona.work (11/18/2016)
Grant Fritchey (11/18/2016)
jasona.work (11/18/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
November 18, 2016 at 8:43 am
jasona.work (11/18/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
November 18, 2016 at 7:22 am
Quest had a tool like that once upon a time. I think it's long been discontinued.
For testing the running of a procedure, it's not hard to write a quick PowerShell...
"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
November 18, 2016 at 6:01 am
Two tools that I would suggest that can help with this (you're still going to have to do a lot of work to understand exactly what is being documented) are...
"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
November 18, 2016 at 5:55 am
Yeah, you're recompiling all the plans after that runs. It might not be that big a deal. It really depends on your system, the code, all sorts of factors. Also,...
"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
November 17, 2016 at 12:29 pm
Ed Wagner (11/17/2016)
I didn't make it through the entire presentation, but I read the announcement - thank you for...
"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
November 17, 2016 at 7:33 am
Another third party tool to check out is Minion Ware. They have a free version of an index management software that does a fantastic job of managing your indexes.
"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
November 17, 2016 at 4:06 am
I'm not sure then.
"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
November 16, 2016 at 12:30 pm
I have never attempted to set up replication to Azure SQL DB. I suppose it will work since it's in the documentation. I'd strongly suggest testing it and setting it...
"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
November 16, 2016 at 11:48 am
Oh, and welcome to the party.
"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
November 16, 2016 at 10:02 am
I strongly recommend getting a copy of Craig Mullins book: Database Administration. It covers the job, as a job. It's technology agnostic. It'll give you a more complete picture of...
"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
November 16, 2016 at 10:01 am
Sounds like you're hitting this issue. Are you sure this is a SQL SErver 2012 instance?
"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
November 16, 2016 at 9:58 am
Add two columns that are only from the Owner. Then set them to null on the second query in the UNION. That ought to return what you're looking for.
"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
November 16, 2016 at 9:56 am
Viewing 15 posts - 4,216 through 4,230 (of 22,224 total)