Viewing 15 posts - 18,676 through 18,690 (of 49,552 total)
IN is for when you have a list of things that you want to compare, not a single name. So if you wanted Mark, William and James, you could do...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 1:33 pm
I doubt the deadlock is the cause. More likely, the deadlocks are another effect.
Deleting lots of rows can be a very expensive query. If it parallels and uses lots of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 1:09 pm
Go check the 'why is my virtual server slow' video here: http://www.idera.com/Education/SQL-server-Webcasts/ or get a consultant in that's familiar with SQL in virtual machines
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 1:07 pm
durai nagarajan (5/1/2012)
Hello,considering same configuration in terms of RAM,Processors and hardware. will it have same performance and the Individual will perform less.
Clustering has nothing to do with performance, it's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 12:58 pm
Well written code and indexes that support the queries.
Partitioning will not improve performance, it's not a magic bullet, it can even make queries slower.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 12:50 pm
MS Access is not an enterprise database solution. It's designed for small desktop databases.
You can get Access to just send the data to SQL, use pass-through queries. That said, it's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 11:26 am
In my experience, unless the queries are pass-through queries, Jet is very fond of pulling all data local and then running the query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 11:18 am
Qutip (5/1/2012)
Do you advise against nolock?
Strongly. It is not a go faster switch. Rather it is a 'I'm happy with slightly incorrect results' switch.
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 10:31 am
vinu512 (5/1/2012)
Also GETDATE() returns the datetime specific to the database including the database time zone offset where as CURRENT_TIMESTAMP doesn't include the database offset.
What do you mean by that?
Getdate and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 2:48 am
No. The service packs work for all editions. The one exception may be express, haven't tested that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2012 at 5:12 pm
No offence, but did you look in Books Online?
Under create index, there's a clear example of creating a partitioned index
CREATE NONCLUSTERED INDEX IX_TransactionHistory_ReferenceOrderID
ON Production.TransactionHistory (ReferenceOrderID)
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2012 at 4:50 pm
I need the EXACT create index statement that you ran, the one that failed.
p.s. If you're partitioning on dates, partition RIGHT, not LEFT. Partitioning left with dates is horrid, and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2012 at 4:27 pm
What's the partition function, what's the exact code you're running?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2012 at 3:50 pm
Yes it should (columns are the same, ordering is the same)
Do feel free to test out on a dev server first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2012 at 3:12 pm
Rich Yarger (4/30/2012)
So - this will rebuild the Clustered Index / Primary Key be to a Unique Clustered Index / Primary Key?
Don't understand, A primary key is always enforced by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2012 at 3:03 pm
Viewing 15 posts - 18,676 through 18,690 (of 49,552 total)