Viewing 15 posts - 91 through 105 (of 440 total)
sknox (6/4/2012)
danl-971512 (6/4/2012)
It also makes it easier to "blow the lid" off of big-int based sequences especially if a single sequence is used in large or huge tables.
And IDENTITY is...
June 4, 2012 at 11:33 am
Lowell (6/3/2012)
scripting options is what you skimmed over; there are lots of stuff you can turn on and off:
At least in my installation, there are no scripting options available in...
June 4, 2012 at 3:50 am
Since this is more or less a copy of a previous article, I chose to copy my comment from that article:
First of all, I don't think this article is comprehensive...
June 4, 2012 at 3:45 am
As far as I can see, this can be done in several ways. If the target for your data also is a SQL Server, then Service Broker is a good...
May 25, 2012 at 1:32 am
As far as I understand it, you will need a license for all four processors, as you cannot guarantee that the two instances are running at the same physical host....
May 22, 2012 at 2:43 am
Kristian, what is the MAXDOP configuration of the server? Is this the customer one from your first post?
As stated in the first post, it is 1. However, this is overridden...
May 17, 2012 at 2:57 pm
Gullimeel (5/17/2012)
May 17, 2012 at 2:54 pm
A small update: The first index just finished, the second started off in parallel as it should just now. So, what I've learned from this situation: If your server happens...
May 16, 2012 at 7:54 am
Thanks for the information. I don't know why I have not already found this page. For the record:
* Resource Governor is not running
* Server CPU load is less than 1...
May 16, 2012 at 7:40 am
I don't quite understand what you mean, but from what I see, this appears to be a job for SQL Server Integration Services (SSIS). I would strongly suggest that xp_cmdshell...
May 16, 2012 at 5:25 am
kennethigiri (4/20/2012)
What settings have you got for growth of database files. Sounds to me that they grow by too little each time. Gain control of the growth of your databases,...
April 20, 2012 at 12:16 pm
kennethigiri (4/20/2012)
We definitely did not do that. The performance problems grew over time.
What settings have you got for growth of database files. Sounds to me that they grow by too...
April 20, 2012 at 11:44 am
mohammed moinudheen (4/20/2012)
Is it possible to check the allocation unit using SQL ServeR?
Not without creating something like a CLR Function.
April 20, 2012 at 11:26 am
kennethigiri (4/20/2012)
I know one can adjust the fill factor to deal with internal fragmentation, what can one do about external fragmentation?
Defragment or even rebuild the index to reduce external fragmentation.
kennethigiri...
April 20, 2012 at 11:24 am
Viewing 15 posts - 91 through 105 (of 440 total)