Viewing 15 posts - 47,521 through 47,535 (of 49,571 total)
Jeff Moden (1/31/2008)
However, the engine has no obligation to scan the table in index order, as there are no language constructs which impose an ordering on the execution order of...
January 31, 2008 at 11:04 pm
You can only have 1 primary key per table, but you can have many unique keys
Primay keys cannot have nulls. A unique key defined on a nullable field can have...
January 31, 2008 at 10:41 pm
Matt Miller (1/31/2008)
January 31, 2008 at 10:23 pm
You could revoke all the table permissions and insist that all data access is via stored procedures. In the stored procs you can check the application name. You can also...
January 31, 2008 at 1:33 pm
One of the easiest ways to count reads is using profiler. Start up a session, trace T-SQL:Stmt_completed and/or T-SQL:BatchCompleted and filter on your login name and/or machine name.
January 31, 2008 at 12:50 pm
It's a full table update, so the entire table has to be locked exclusively anyway until the update has completed, whether by a (forced) table lock or multiple row/page locks....
January 31, 2008 at 11:53 am
My mistake. I missed the TablockX hint. Replied without checking back to the article.
Edit: And even if the tablockX hint wasn't there, the statement in question is an update....
January 31, 2008 at 10:59 am
Than I'm stumped. Sorry. Maybe someone else here has an idea. If you're got a support contract with MS, consider logging a case with PSS.
I've had very bad experiences with...
January 31, 2008 at 10:55 am
TheSQLGuru (1/31/2008)
5) Enterprise Edition where you start the run while another scan is ongoing. The "join-along" capability of EE will jump on the existing read thread, then loop around...
January 31, 2008 at 10:37 am
Please in the future post schema, sample data and expected results. See - http://www.sqlservercentral.com/articles/Best+Practices/61537/
First question - is this homework?
You need a group by on classID and a max on...
January 31, 2008 at 10:05 am
Very nice, and thanks for the link.
January 31, 2008 at 9:54 am
What recovery mode is your database in? If bulk logged, are you doing any bulk operations (bcp, bulk insert, select into, index rebuilds)?
January 31, 2008 at 6:41 am
Are you asking how to shink the database and not the log? You'd do it by shrinking each of the data files individually.
Note Steve's warning above. You don't want to...
January 31, 2008 at 6:37 am
I'll have a go at it later this evening, if someone else doesn't reply first.
January 31, 2008 at 6:36 am
Very few situations. iirc the only time you want to consider fibres is whn the CPUs are spending a large portion of their time doing context switches.
A lot of stuff...
January 31, 2008 at 4:37 am
Viewing 15 posts - 47,521 through 47,535 (of 49,571 total)