Viewing 15 posts - 35,551 through 35,565 (of 49,552 total)
Sherri Barkley (12/1/2009)
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
December 2, 2009 at 12:10 am
Few things. You're going to get a syntax error from that saying that the name column is ambiguous. You need to specify the table and column name in the piece...
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
December 1, 2009 at 2:11 pm
This should work on SQL 2000
select 'alter table ' + sysusers.name + '.' + tables.name
+ ' alter column ' + columns.name +
case columns.xtype
...
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
December 1, 2009 at 1:31 pm
homebrew01 (12/1/2009)
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
December 1, 2009 at 1:04 pm
rahulsony111 (12/1/2009)
i should use a stored procedure cause it will be used very often
Why would you be doing data type changes very often?
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
December 1, 2009 at 1:02 pm
Matt Miller (#4) (12/1/2009)
Considering we're looking at a dev edition error log, this is possibly someone shutting the machine down (which could be a workstation and not a server).
If SQL...
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
December 1, 2009 at 12:54 pm
Jeff Moden (12/1/2009)
Heh... clever startup procedure trick by a laid off employee???
Not unless there's a WAITFOR DELAY 2 hours before the SHUTDOWN. Possible though, evil thing to do. Wouldn't 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
December 1, 2009 at 12:51 pm
homebrew01 (12/1/2009)
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
December 1, 2009 at 12:48 pm
Dynamic SQL. No other practical way. Watch out for SQL injection....
Question I have is why a stored procedure? Are you expecting data type changes to happen so often that 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
December 1, 2009 at 12:44 pm
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic826906-8-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
December 1, 2009 at 12:42 pm
Are you sure that the SAN LUN was present and available at the time the SQL Service started? Could it have been that the drive only became available afterwards?
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
December 1, 2009 at 12:34 pm
Ok, it's literally an internal per-database flag that says if there's an existing full backup for the purposes of running a diff. If the flag isn't set, diff's will fail....
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
December 1, 2009 at 12:30 pm
Link to article please? Not sure what it's talking 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
December 1, 2009 at 11:38 am
Just bear in mind that unless you did the backup with the CheckSum option, a successful RESTORE VERIFYONLY does not guarantee that the backup is restorable. As far as I'm...
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
December 1, 2009 at 10:08 am
Good to hear it's fixed. If you haven't already, get the server admins to run some checks on the disk, make sure there are no lingering problems
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
December 1, 2009 at 9:54 am
Viewing 15 posts - 35,551 through 35,565 (of 49,552 total)