Viewing 15 posts - 47,356 through 47,370 (of 49,571 total)
karthikeyan (2/20/2008)
I have attended an interview two weeks back. He asked me the mentioned question.
There's not enough context to know what he was asking about
Gila, are you from US or...
February 20, 2008 at 12:59 am
Local System is an account that has administrator rights on the local machine and NO rights to any other machine.
If you want SQL to be able to backup and restore...
February 19, 2008 at 10:38 pm
Maybe, depends on what the table looks like. What's your intention with that complex expression in the count?
Can you post the table's schema and the index definitions please.
February 19, 2008 at 5:48 am
Doing a reindex right after a defrag is redundant and a waste of time and server resources
A reindex does all that a defrag does and more.
You would typically use a...
February 19, 2008 at 2:59 am
One this that may make a small difference, you don't need a distinct in a subquery used in an IN clasue.
Can you post the schema of the tables and the...
February 19, 2008 at 2:43 am
Reindex completely rebuilds the index, removing fragmentation at all levels.
Index Defrag shuffles the leaf pages into order, removing fragmentation at the leaf levels, but potentially leaving fragmentation at the other...
February 19, 2008 at 12:35 am
There are thee types of 'temp' tables, all stored in the tempDB database.
Global Temp Tables.
Created by CREATE TABLE ##MyTempTable AS ...
They are visible to all sessions. If not explicitly dropped,...
February 18, 2008 at 1:12 am
Haven't heard of this happening before.
Can you post the trigger code, the table schema and the insert statement that you tried?
What's the version of your SQL server? What SP?
February 17, 2008 at 11:53 pm
Really strange.
Can you run a checkdb on the database, just to make sure that there's no corruption lurking. You can also try rebuilding the indexes on those tables
February 17, 2008 at 10:55 pm
What is sccm 2007, and why does it need full, unrestricted access to your SQL Server?
February 15, 2008 at 1:45 am
Are you running SQL 2000 or 2005?
In 2005, DBCC PinTable is a no-op. It's deprecated and ignored.
Not sure, in 2000, how to find pinned tables, but if you want to...
February 15, 2008 at 12:08 am
I would store it in an int field as the number of minutes. The presentation as hours and minutes can be sone on querying, either in a proc or on...
February 14, 2008 at 12:27 pm
2 recommendations, one request.
I strongly recommend the following two books
Guru's guide to SQL Server architecture and internals by Ken Henderson. It was written for SQL 2000, but is still...
February 14, 2008 at 12:26 pm
What were they blocking on?
February 14, 2008 at 11:11 am
Never seen that myself. Shouldn't be possible.
Post queries please?
February 14, 2008 at 11:11 am
Viewing 15 posts - 47,356 through 47,370 (of 49,571 total)