Viewing 15 posts - 6,616 through 6,630 (of 49,552 total)
While that could work, it's possible you could end up fixing deadlocks that you won't get in prod. Unless you have a lot of spare time, maybe rather look at...
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
February 4, 2015 at 10:45 pm
Edit: No, it's me who mis-read the question.
A nonclustered index can only ever contain a column once. Hence if you explicitly reference a column that's implicitly in the index already,...
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
February 4, 2015 at 10:39 pm
Brandie Tarvin (2/4/2015)
GilaMonster (2/4/2015)
Ed Wagner (2/4/2015)
GilaMonster (2/4/2015)
Brandie Tarvin (2/4/2015)
GilaMonster (2/3/2015)
And spending the evening at the office because there are scheduled blackouts in my area. Again.
Scheduled blackouts? Is the electrical grid...
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
February 4, 2015 at 6:16 am
Ed Wagner (2/4/2015)
GilaMonster (2/4/2015)
Brandie Tarvin (2/4/2015)
GilaMonster (2/3/2015)
And spending the evening at the office because there are scheduled blackouts in my area. Again.Scheduled blackouts? Is the electrical grid overworked?
Yup, since 2008.
So,...
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
February 4, 2015 at 5:46 am
Brandie Tarvin (2/4/2015)
GilaMonster (2/3/2015)
And spending the evening at the office because there are scheduled blackouts in my area. Again.Scheduled blackouts? Is the electrical grid overworked?
Yup, since 2008.
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
February 4, 2015 at 5:24 am
You can't include a column that's already in the key.
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
February 4, 2015 at 5:23 am
No, most used has nothing to do with 'should be indexed'. What if the most used is always in a select and never in the where. Indexing is a little...
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
February 4, 2015 at 4:02 am
No, and most used does not mean that it must be indexed. Indexing is a little more complex than that.
See the entries on my blog in the indexing category.
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
February 4, 2015 at 3:03 am
RonKyle (2/3/2015)
There are cases where using a GUID as the primary key is valid. The problem comes if you also make it your clustered index.
These cases are rare. To...
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
February 4, 2015 at 12:58 am
Hadrian (2/3/2015)
Move or copy the backup of the server certificate and the private...
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
February 3, 2015 at 1:39 pm
Hadrian (2/3/2015)
So in conclusion without password we cannot restore our encrypted database?Thanks very much
Are you reading anything I write?
Server A is online and working.
Server A contains a working, accessible copy...
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
February 3, 2015 at 1:37 pm
And spending the evening at the office because there are scheduled blackouts in my area. Again.
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
February 3, 2015 at 12:12 pm
Once more with feeling....
Take a new backup of the certificate. If you can't, see my earlier post about changing the certificate.
The existing password on the existing certificate backup is irrelevant...
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
February 3, 2015 at 7:17 am
What about the source server, where the database currently is? Or is that gone too?
What, exactly, is the situation with regard to this database?
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
February 3, 2015 at 6:01 am
Stephanie Giovannini (2/2/2015)
What is best practice for storing time intervals in a table?
I would use an integer and define that it's a number of minutes, seconds or hours as necessary
...
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
February 3, 2015 at 4:41 am
Viewing 15 posts - 6,616 through 6,630 (of 49,552 total)