Viewing 15 posts - 6,616 through 6,630 (of 49,571 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...
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,...
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...
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,...
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.
February 4, 2015 at 5:24 am
You can't include a column that's already in the key.
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...
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.
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...
February 4, 2015 at 12:58 am
Hadrian (2/3/2015)
Move or copy the backup of the server certificate and the private...
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...
February 3, 2015 at 1:37 pm
And spending the evening at the office because there are scheduled blackouts in my area. Again.
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...
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?
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
...
February 3, 2015 at 4:41 am
Viewing 15 posts - 6,616 through 6,630 (of 49,571 total)