Viewing 15 posts - 37,201 through 37,215 (of 49,552 total)
vishal (8/9/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
August 10, 2009 at 1:42 am
The corrected version is here: http://www.sqlservercentral.com/Forums/Topic767556-9-1.aspx
Threads can't be deleted here except by a moderator. No worries, if it happens again, just edit the first post to be a link 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
August 9, 2009 at 3:40 pm
Phil Factor (8/9/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
August 9, 2009 at 12:51 pm
Depends where you are sitting in the world. Where I am, backing up into the cloud is just not an option, it's not security or risk, it's simple time, bandwidth...
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
August 9, 2009 at 12:44 pm
rsteckly (8/9/2009)
Does anyone have a sample SLA for a SQL Server DBA? I need one to use a template...
An SLA is something that you need to get from your...
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
August 9, 2009 at 12:37 pm
5-year old thread alert.
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
August 9, 2009 at 12:33 pm
Also note that indexes that have not been used at all (no seeks, no scans, no lookups, no updates) will not appear in index_usage_stats. An index has to be used...
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
August 9, 2009 at 12:31 pm
msc (8/8/2009)
CREATE DATABASE [dbname] ON(NAME = Name, FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\db.mdf')
FOR ATTACH_REBUILD_LOG;
That only works if the database has been shut down cleanly. If it has...
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
August 9, 2009 at 2:00 am
Paul White (8/8/2009)
GilaMonster (8/7/2009)
Anyone really know their way around replication?http://www.sqlservercentral.com/Forums/Topic766992-146-1.aspx
Could the OP have made any less effort in that thread?
It's possible, difficult, but possible.
Here's another very terse question. I think...
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
August 8, 2009 at 2:41 am
Bob Hovious (8/7/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
August 8, 2009 at 2:39 am
Performance Monitor. Look for the Transactions/sec counter.
Profiler. Look for the RPC:Completed and T-SQL Batch Completed events.
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
August 8, 2009 at 2:38 am
jose (8/8/2009)
EXEC sp_detach_db @dbname = 'pubs'
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
sp_attach_single_file_db attaches...
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
August 8, 2009 at 2:30 am
imSQrLy (8/7/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
August 7, 2009 at 3:21 pm
Easier to understand if you switch them around.
In is looking for matching in a list of values. So a where clause predicate like this one
WHERE SomeColumn IN (1,2,3,4,5)
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
August 7, 2009 at 3:01 pm
That's SQLMag, not SSC. Thread topics drift here, Steve doesn't intervene unless there are personal insults flying around, which doesn't happen often. Sometimes they drift back on topic, sometimes they...
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
August 7, 2009 at 2:51 pm
Viewing 15 posts - 37,201 through 37,215 (of 49,552 total)