Viewing 15 posts - 38,356 through 38,370 (of 49,552 total)
Dugi (6/18/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
June 18, 2009 at 5:08 am
Open Books Online (the SQL help file) and look up Linked Servers. Or, if you prefer the online version: http://msdn.microsoft.com/en-us/library/ms188279(SQL.90).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
June 18, 2009 at 4:55 am
Don't shrink the database. See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
If the log space isn't been reused, there's something still active in the older log records. Take a look at sys.databases. There's a column...
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
June 18, 2009 at 4:44 am
That trigger is written assuming there's only one row in the inserted/deleted tables. If more than one row was updated, the trigger fires once and there'll be more than one...
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
June 18, 2009 at 4:43 am
MVP is not a certification. You can't directly compare it to the MCM, MCA certs. Plus, there are only (iirc) 3 MCM certs available - Exchange, sharepoint, SQL Server. MVPs...
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
June 18, 2009 at 4:41 am
Best advice I can give you for an interview is relax, don't exagerate your abilities and don't be afraid to say 'I don't know', though have an idea how to...
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
June 18, 2009 at 4:34 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
June 18, 2009 at 1:36 am
CREATE TABLE zzdbfiles.dbfiles (
....
)
INSERT INTO zzdbfiles.dbfiles
EXEC sp_MSforeachdb @command1 = 'select name, physical_name, state_desc, size, max_size, growth from ?.sys.database_files'
You have to explicitly create the table first. Select ... Into cannot use...
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
June 18, 2009 at 1:34 am
Manie Verster (6/17/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
June 18, 2009 at 1:27 am
RBarryYoung (6/17/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
June 17, 2009 at 2:08 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/Topic736889-17-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
June 17, 2009 at 2:00 pm
Randolph Potter (6/17/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
June 17, 2009 at 1:55 pm
Florian Reischl (6/17/2009)
Erm... Just played with this nullbuster. This might be an important information for you:
This feature works find on SSE2k5 but it does not work anymore on SSE2k8 for...
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
June 17, 2009 at 1:53 pm
If it's OLTP I'd consider dropping the MAXDOP to 4 or even 2. Combine that with optimising the worst offending queries, and you may get this under control fairly well.
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
June 17, 2009 at 1:50 pm
digitalox (6/17/2009)
Is it the format of #xxxxxx that implies that is a table variable vs. temp table?
Yes. Temp tables have a name in TempDB that includes the name given...
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
June 17, 2009 at 10:29 am
Viewing 15 posts - 38,356 through 38,370 (of 49,552 total)