Viewing 15 posts - 91 through 105 (of 155 total)
As mentioned earlier, SQL Server will use as much memory as you allow it to. If, in your case, you need to have more than 1.5 GB available, then...
July 15, 2010 at 4:41 am
The best way of learning interview questions is to give it a shot.
Here's the relevant syntax from Books Online (from the article on CREATE TABLE):
[ CONSTRAINT constraint_name ]
{ ...
July 15, 2010 at 1:53 am
There's also XML indexes (http://msdn.microsoft.com/en-us/library/ms345121(SQL.90).aspx) in 2005 onwards.
I wouldn't call filtered indexes a separate type of index. Oracle also has the concept of a bitmap index, but...
July 15, 2010 at 1:43 am
What exactly is the problem? Are you concerned that SQL Server is caching your data? Do you need the memory spare for another application on this server? How much...
July 15, 2010 at 12:41 am
PCI compliance can be a hairy topic. Are you concerned with masking the data, and never getting the original values back, or encrypting it, and just masking it most...
July 14, 2010 at 8:42 pm
After a quick look, and assuming that the 85% query cost is correct, I've a couple of observations.
You're truncating the GMTVision table. It is probably worth disabling the indexes...
July 14, 2010 at 8:29 pm
sturner (7/14/2010)
July 14, 2010 at 2:17 pm
Using DBCC LOG ('SplitPageTest', 4), I've tracked the entries in the log for the example given in your sample code, and a slightly modified version that uses a UNIQUEIDENTIFIER as...
July 14, 2010 at 1:59 pm
RakeshRSingh (7/13/2010)
I am using perfmon to track Page Split/Sec event
The problem with page split counters is that they will fire whenever a new page is allocated, and not just when...
July 14, 2010 at 12:27 am
How are you measuring whether or not you're getting page splits?
July 13, 2010 at 11:57 pm
CirquedeSQLeil (7/13/2010)
Grant Fritchey (7/13/2010)
This document sounds like it's a doozy.That's an understatement.
On the plus side, it is providing me with good fodder for a blog post.
I love reading those sorts...
July 13, 2010 at 10:27 pm
Your assumption that indexes are stored in memory is slightly incorrect. All data, whether from a table (heap or clustered index), or a non-clustered index, is stored on disk,...
July 13, 2010 at 8:15 pm
A possible option is to make it a rule to never click on the "Logins" node in Object Explorer without right clicking it and selecting "Filter" first. However, you'll...
July 13, 2010 at 2:23 pm
To tell the truth, I've never worried too much about resource usage with server-side traces. I'm more interested in how many GB per hour the trace is likely to...
July 13, 2010 at 5:00 am
All execution plans for that table will be invalidated when the clustered index goes, so yes, a new plan will be generated.
July 13, 2010 at 4:09 am
Viewing 15 posts - 91 through 105 (of 155 total)