Gail Shaw

Forum Replies Created

Viewing 15 posts - 12,856 through 12,870 (of 49,552 total)

RE: SQL Server Startup Options

-F or -f?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 9, 2013 at 12:47 pm

#1622276
RE: Introduction to Indexes: Part 3 – The nonclustered index

Dird (6/8/2013)
This was so interesting 😮 went through it along with the simple-talk tracing articles & just finished (slow reader -_). I'm gonna read through your other articles tomorrow (or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 9, 2013 at 3:58 am

#1622269
RE: Effect of indexes in SQL Server Performance Tuning

No, it writes continuously.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 9:41 am

#1622234
RE: Does a backup cause TempDB to grow

Backups do not use TempDB.
Does the backup job do anything other than take a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 8:00 am

#1622228
RE: My VIEW doesnt use Index.

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 *...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 7:57 am

#1622227
RE: Effect of indexes in SQL Server Performance Tuning

Dird (6/8/2013)
1. You said you were going to add the modified date to the index but ended creating a completely new index (different name); does that mean the old index...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 7:50 am

#1622226
RE: why we need secondary(.ndf) file in Database

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 6:10 am

#1622222
RE: Effect of indexes in SQL Server Performance Tuning

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/
http://www.amazon.com/Server-Query-Performance-Tuning-ebook/dp/B008E6HOIS/
and indexing
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 1:19 am

#1622216
RE: Rollback statement in T-SQL

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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 1:16 am

#1622215
RE: DEFAULT Constraint syntax

Please note: 3 year old thread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 8, 2013 at 1:13 am

#1622214
RE: Any Tool / Application to read SQL Server Database Fragramentation ?

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 7, 2013 at 3:23 pm

#1622198
RE: Any Tool / Application to read SQL Server Database Fragramentation ?

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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 7, 2013 at 2:27 pm

#1622178
RE: Certification Question: You need to ensure the successful recovery of any single database from a catastrophic failure without requiring backup data center in a different location

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 7, 2013 at 12:11 pm

#1622149
RE: Are the posted questions getting worse?

Anyone? http://www.sqlservercentral.com/Forums/Topic1460028-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 7, 2013 at 5:05 am

#1622024
RE: How can we find the Null values on indexed columns from all tables in SQL Server.

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

June 7, 2013 at 3:26 am

#1622011

Viewing 15 posts - 12,856 through 12,870 (of 49,552 total)