Viewing 15 posts - 23,776 through 23,790 (of 49,552 total)
You can't remove the index enforcing the primary key constraint without removing the primary key. That may not be a good idea.
Whether that's the best place for the clustered index...
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
September 1, 2011 at 6:12 am
paul.knibbs (9/1/2011)
I'm still not sure this offers a major advantage! You're just moving the 50Gb of disk space usage from one place to another.
The log backup if you'd done 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
September 1, 2011 at 4:08 am
paul.knibbs (9/1/2011)
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
September 1, 2011 at 2:58 am
David.Poole (9/1/2011)
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
September 1, 2011 at 2:56 am
tfifield (8/31/2011)
If you really need all columns returned, then by all means use SELECT *.
Even if every single one really is needed, they should still be explicitly named. Tomorrow 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
August 31, 2011 at 1:15 pm
sam-1083699 (8/29/2011)
I need to select all columns so you suggest me to write a select statement with all columns instead of select * ??
Yes. Select the absolute minimum of...
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 31, 2011 at 1:13 pm
fflores 21886 (8/31/2011)
I had only one left license left so I thought to use it. What other version I can use that I don't...
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 31, 2011 at 1:02 pm
You can log ship 2000 - 2008, but the secondary database will be in the restoring state and will be completely inaccessible.
Perhaps replication is more what you need (but replicating...
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 31, 2011 at 12:54 pm
Yes. See tomorrow's headline article.
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 31, 2011 at 12:50 pm
SQLRNNR (8/31/2011)
Those databases if not maintained can pose a risk and threat to your entire environment.
Yup. Sooner or later some senior manager's going to come storming to you screaming that...
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 31, 2011 at 12:48 pm
Why standard edition? Unless you have an MSDN subscription, you will have to pay licensing on that and Standard edition isn't cheap.
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 31, 2011 at 12:47 pm
Patch levels and associated vulnerabilities.
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 31, 2011 at 12:17 pm
xgcmcbain (8/31/2011)
lets say there is a composite index on firstname, lastname, and companyidbut i have a query that just has companyid in the where clause
is a separate companyid index required?
If...
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 31, 2011 at 12:15 pm
What version of SQL is that on, the 2000 or the 2008?
SELECT @@version?
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 31, 2011 at 10:21 am
Please post the entire deadlock graph in its XML format
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 31, 2011 at 9:51 am
Viewing 15 posts - 23,776 through 23,790 (of 49,552 total)