Viewing 15 posts - 5,326 through 5,340 (of 22,227 total)
Yep. I get it. Log files. Created when you create a database. The process of creating that database is to copy what's in the "model" system database. I suspect if...
"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
December 10, 2015 at 12:00 pm
Without seeing the actual structure and queries, these are, at best, suggestions for testing.
rhans (12/10/2015)
"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
December 10, 2015 at 11:07 am
Grant Fritchey (12/10/2015)
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad thing would be the people who...
"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
December 10, 2015 at 9:01 am
Then the first index I'd put on the table is the clustered index. And, if you're going to be using this month field for lots of deletes, it might make...
"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
December 10, 2015 at 8:57 am
You'll want to look at the WITH MOVE option if the disks are configured differently between the two servers. But yeah, a RESTORE in a situation like this is extremely...
"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
December 10, 2015 at 8:48 am
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad thing would be the people who don't get...
"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
December 10, 2015 at 8:46 am
karthik82.vk (12/10/2015)
Hi,I am thinking of creating a column store index for the table i am using?
Is there any specifications for creating it?
Yeah, tons! Go and read the documentation. It's vital.
"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
December 10, 2015 at 8:07 am
Steve Jones - SSC Editor (12/9/2015)
"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
December 10, 2015 at 3:56 am
I agree with Jayanth, for specific advice, the query and the existing execution plan.
But, general advice, yes, a non-clustered index can be used in an UPDATE statement to help 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
December 10, 2015 at 3:45 am
A single SELECT statement without any kind of filtering offers very little in the way of query tuning. A scan is the best way to access the data in this...
"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
December 10, 2015 at 3:44 am
Take a look at the model database on the servers. I'm pretty sure that determines how things are set by default.
"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
December 10, 2015 at 3:41 am
That's a no-go here too. I set up the test like this:
CREATE PROC dbo.ExEventTest (@ID INT)
AS
SELECT *
FROM dbo.Test1 AS t
WHERE t.ID = @ID;
GO
CREATE PROC...
"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
December 9, 2015 at 8:56 am
SQL Guy 1 (12/9/2015)
Yes, it's for debugging. If it's impossible with trace, what other means can I use? Will extended events or reading transaction log give me these values?
It's...
"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
December 9, 2015 at 7:33 am
SoHelpMeCod has already pointed out the issue. You don't have a defined primary key on the table.
We're all over the map here, bouncing from one thing to another. You need...
"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
December 9, 2015 at 4:45 am
Looks like that's being called from within another procedure. Unless you also capture that procedure, I don't know of a way to do this using trace.
"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
December 8, 2015 at 11:15 am
Viewing 15 posts - 5,326 through 5,340 (of 22,227 total)