Viewing 15 posts - 29,761 through 29,775 (of 49,552 total)
tnk (10/24/2010)
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
October 24, 2010 at 11:43 pm
Think you could perhaps be a little more specific about what you want?
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
October 24, 2010 at 11:28 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1009755-1633-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
October 24, 2010 at 11:21 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1009782-1549-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
October 24, 2010 at 11:20 pm
That error can mean just about anything.
If you rebuild manually, does it work?
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
October 24, 2010 at 3:41 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1009735-1351-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
October 24, 2010 at 3:32 pm
Shrinking logs once-off (after bad maintenance) is one thing. Shrinking in a maint plan (scheduled) is a seriously bad idea. The logs are just going to grow again unless you've...
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
October 24, 2010 at 3:31 pm
I lied, no need for LEN. :hehe:
DECLARE @FileName VARCHAR(50) = '10494B-XL-Large.jpg';
SELECT REVERSE(RIGHT(REVERSE(@FileName), CHARINDEX('-', REVERSE(@FileName) ,0)-1));
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
October 24, 2010 at 2:02 pm
Old, old trick. Most commonly used for extracting just the file name or just the folders from a full path - C:\Some\Odd\Dir\Thisfile.txt
Not just a T-SQL trick.
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
October 24, 2010 at 1:49 pm
You want to remove the second hyphen and everything after it?
If there will only ever be two hyphens, reverse the string, take everything to the right of the first hyphen,...
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
October 24, 2010 at 1:33 pm
I know of a local company that has lots (30+) MSDE installations all on RTM or SP1. I've warned them a couple times about what will happen if Slammer gets...
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
October 24, 2010 at 12:51 pm
Jeff Moden (10/24/2010)
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
October 24, 2010 at 12:49 pm
Jeff Moden (10/24/2010)
a lot of country's governments bailed out their own banking systems...
Not ours. Our banking system was never in trouble, due to some banking laws that have been...
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
October 24, 2010 at 12:43 pm
Not over. Not globally anyway.
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
October 24, 2010 at 11:24 am
Query sys.dm_sql_referenced_entities, or do wildcard searches through sys.sql_modules to find affected procs
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
October 24, 2010 at 11:23 am
Viewing 15 posts - 29,761 through 29,775 (of 49,552 total)