Viewing 15 posts - 8,731 through 8,745 (of 22,224 total)
I don't think that's a mirroring or replication error, so it's likely that it's coming from the client application. If so, yeah, it's likely that you need to do some...
"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
March 10, 2014 at 5:49 am
Koen Verbeeck (3/10/2014)
Grant Fritchey (3/10/2014)
You should just be able to attach the database file directly to SQL Server. Is that what you're trying to do?
Earlier versions of AdventureWorks had some...
"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
March 10, 2014 at 3:43 am
I would also suggest you build your databases such that the columns that are meant to be numbers are stored as numbers, not strings.
"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
March 10, 2014 at 3:41 am
You should just be able to attach the database file directly to SQL Server. Is that what you're trying to do?
"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
March 10, 2014 at 3:39 am
If you are moving into very large sets of data, you might want to consider using bigint out of the box. That will be wider on your indexes, but 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
March 10, 2014 at 3:38 am
What you're looking to do is use the GRANT command to give people access to a particular table. There's an example at the link. You can combine that with 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
March 10, 2014 at 3:35 am
ananda.murugesan (3/10/2014)
GilaMonster (3/10/2014)
Still not following.Are you talking about the primary key constraint? Or some other constraint? What exactly is the problem here?
Yes. I am talking about Primary Key constraint., Not...
"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
March 10, 2014 at 3:23 am
MyDoggieJessie (3/9/2014)
Wow Grant, that "SQL Server 2012 Query Performance Tuning" book is $40- do we get an SSC discount? 😀
Ha! Price is set by Apress. They've actually come down some...
"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
March 10, 2014 at 3:17 am
jaminbw (3/9/2014)
Thanks for this article. I relate to this so much.
I do want to be responsive to needs of operations but, I hate how often I am seen as...
"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
March 10, 2014 at 3:16 am
PRR.DB (3/9/2014)
Grant Fritchey (3/9/2014)
If we're talking SQL Server 2012, you can use a SEQUENCE. There are a nuber of examples on the documentation page.
i think sequence for only integer datatypes...
"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
March 9, 2014 at 6:02 am
Perfmon doesn't show that type of material. You'll want to capture query metrics using a server-side trace (not Profiler, don't run the GUI against production machines) or extended events. But...
"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
March 9, 2014 at 5:46 am
I'd go with a pre-built script to do the heavy lifting. I like Michelle Ufford's scripts[/url] for doing this. Others like Ola Hollengren'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
March 9, 2014 at 4:52 am
If we're talking SQL Server 2012, you can use a SEQUENCE. There are a number of examples on the documentation page.
"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
March 9, 2014 at 4:51 am
If you're not using SQL Server 2000, you should be avoiding aliasing users. sp_addalias is deprecated functionality. I don't even think it's available in SQL Server 2008 or higher. 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
March 9, 2014 at 4:48 am
aviadavi (3/9/2014)
one more thing,How can I know (during load) if the SQL is now in bottleneck ?
You're either seeing long wait times, or blocked processes, or both. If you're seeing...
"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
March 9, 2014 at 4:36 am
Viewing 15 posts - 8,731 through 8,745 (of 22,224 total)