Gail Shaw

Forum Replies Created

Viewing 15 posts - 21,631 through 21,645 (of 49,552 total)

RE: Trigger into SPROC

I'm not even sure what you're trying to do. Can you explain in more detail (just that portion, not the overall code)
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

December 20, 2011 at 8:40 am

#1423684
RE: Unable to remove t-log file

Getting there slowly...
GilaMonster (12/20/2011)
What's the output of DBCC OPENTRAN? What's the status of the log reader?
Please take a read through this if you haven't already (I know there are some...
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

December 20, 2011 at 8:40 am

#1423683
RE: Wierd Index Issue on DateTime Column

Charlottecb (12/20/2011)
Since I don't know exactly what time of the day the majority of records will be loaded, I was thinking of putting a small utility into the front-end app...
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

December 20, 2011 at 8:38 am

#1423681
RE: Will ALTER INDEX ... REBUILD WITH (ONLINE = OFF) Blocked The Full Backup Job?

Bhuvnesh (12/20/2011)
logically, updating an index and doing backup doesn't suit as updated index should go into backup file.
And depending when the index change finishes and at what point the...
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

December 20, 2011 at 8:37 am

#1423678
RE: sql query to format numbers

This kind of formatting should be done in the front end. SQL doesn't have a lot of string formating functions (which front end apps tend to do) and presentation should...
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

December 20, 2011 at 4:00 am

#1423543
RE: Unable to remove t-log file

GilaMonster (12/20/2011)
What's the size of the log? What's the % used? What's the log_reuse_wait_desc? What's the output of DBCC OPENTRAN? What's the status of the log reader?
Not asking for my...
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

December 20, 2011 at 3:54 am

#1423539
RE: SQL query to handle date range criteria

That doesn't satisfy the 2nd of your requirements
2)user should not see data if the entered date is future date.
With the query that you've written, rows with dates in the future...
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

December 20, 2011 at 3:43 am

#1423529
RE: Wierd Index Issue on DateTime Column

This likely has nothing to do with fragmentation at all. I suspect you've run into this issue:http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/
Very common on ascending columns where the queries want latest data (or reasonably latest)....
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

December 20, 2011 at 3:36 am

#1423523
RE: Unable to remove t-log file

You can't remove the first log file that the database had. If you add other log files you can remove them, but the first one has to stay.
Why do you...
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

December 20, 2011 at 3:30 am

#1423522
RE: Will ALTER INDEX ... REBUILD WITH (ONLINE = OFF) Blocked The Full Backup Job?

durai nagarajan (12/20/2011)
My question is will the backup wait for the current activities and backup those activities log as well.
I just answered that. No, a backup is not blocked (will...
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

December 20, 2011 at 3:21 am

#1423520
RE: Blocking/Locking Question

raotor (12/20/2011)
As I understand it, a "page" is an 8K block of data that can encapsulate more than one row of data from a table and as such a lock...
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

December 20, 2011 at 3:20 am

#1423519
RE: Using sys.index_columns

Hmm, this looks familiar. 😉
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

December 20, 2011 at 3:18 am

#1423515
RE: Will ALTER INDEX ... REBUILD WITH (ONLINE = OFF) Blocked The Full Backup Job?

durai nagarajan (12/20/2011)
Gail,
Will the backup job wait for the activities( currently running ) to finish and backup the log.
No. A backup is not blocked by any data modification queries.
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

December 20, 2011 at 2:51 am

#1423504
RE: Blocking/Locking Question

One thing to note about the locking hints is that they specify the minimum, not the actual that will be used. You can specify rowlock and still get a table...
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

December 20, 2011 at 2:50 am

#1423503
RE: Blocking/Locking Question

SQL will take locks at the lowest granularity it can. It depends on how many rows SQL thinks will be affected. If its a small number, row locks are taken....
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

December 20, 2011 at 2:47 am

#1423502

Viewing 15 posts - 21,631 through 21,645 (of 49,552 total)