Viewing 15 posts - 12,856 through 12,870 (of 49,552 total)
Dird (6/8/2013)
June 9, 2013 at 3:58 am
No, it writes continuously.
June 8, 2013 at 9:41 am
Backups do not use TempDB.
Does the backup job do anything other than take a backup?
June 8, 2013 at 8:00 am
It's perfectly expected, a case statement is not a SARGable expression, so no index seek possible.
CREATE VIEW MyView
AS
SELECT
CASE WHEN (Col2 > 0) THEN Col1 END AS Col1,
Col2
FROM MyTable
The query
SELECT *...
June 8, 2013 at 7:57 am
Dird (6/8/2013)
June 8, 2013 at 7:50 am
The extensions are just a naming convention, nothing more. A secondary data file is a secondary data file, whether it has the mdf extension, the ndf extension or any other...
June 8, 2013 at 6:10 am
There's no such thing as a nested transaction, it's a syntactical lie. The earlier one realises that, the better.
A rollback will roll back ALL changes made in the current transaction,...
June 8, 2013 at 1:16 am
sqlsurfing (6/7/2013)
I wanted to see the internals if after the full index re-builds of all tables things are truly "de-fragmented"
If you've rebuilt the indexes, then the indexes are about...
June 7, 2013 at 3:23 pm
If your indexes have just been rebuilt, then you probably don't have much logical fragmentation.
Red Gate's got a tool to show you index fragmentation. Free tool last time I checked,...
June 7, 2013 at 2:27 pm
Where did you get that question from?
If it's one of those braindump sites with real questions regardless of where the answers came from, you may want to take a look...
June 7, 2013 at 12:11 pm
June 7, 2013 at 5:05 am
bslchennai (6/6/2013)
Yes, i have to take care of all null values because in our database we should not insert null values on indexed columns.
Why not? What's the problem with...
June 7, 2013 at 3:26 am
Viewing 15 posts - 12,856 through 12,870 (of 49,552 total)