Viewing 15 posts - 8,716 through 8,730 (of 22,214 total)
But that's only the "most used" since the last time those values were reset. If the server was restarted last week, a completely different set of indexes might be listed...
March 10, 2014 at 10:56 am
March 10, 2014 at 10:30 am
There's a minimal number of columns that you must have for the replay mechanism to work. And yeah, it collects a lot of data. Only way to deal with it...
March 10, 2014 at 10:05 am
Stuart Davies (3/10/2014)
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...
March 10, 2014 at 8:55 am
Ha! Thanks.
Been accused of being pompous lately and not sure I should be using words like sclerotic. But as long as people know what they mean and they do...
March 10, 2014 at 8:26 am
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...
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...
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.
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?
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...
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...
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...
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...
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...
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...
March 9, 2014 at 6:02 am
Viewing 15 posts - 8,716 through 8,730 (of 22,214 total)