Viewing 15 posts - 39,331 through 39,345 (of 49,552 total)
Explain a bit more please?
Do you just want to know what indexes have more than one column in them, or do you want to list the columns as well?
Either way,...
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
May 4, 2009 at 3:36 am
Since you're on SQL 2005, use the Row_Number() function
SELECT groupid, days_remaining
FROM
(SELECT groupid, days_remaining, Row_Number() OVER (Partition By groupid order by days_remaining) AS RowNo FROM reminder) sub
WHERE RowNo = 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
May 4, 2009 at 3:34 am
darth.pathos (5/3/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
May 4, 2009 at 3:17 am
Can you post the execution plan please, not an image of it? I need to see the properties of all the operators.
Right click the plan, select save as. Save as...
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
May 4, 2009 at 3:15 am
SQL 2005 has built in column-level encryption. SQL 2008 has built in database-level encryption (transparent database encryption)
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
May 3, 2009 at 4:17 pm
If you look in sysindexes, the clustered index is the one that has an indid of 1. Nonclustered indexes have indids between 2 and 249.
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
May 3, 2009 at 4:13 pm
Try this
SELECT o.name FROM
sysobjects o LEFT OUTER JOIN
(SELECT id, indid FROM sysindexes WHERE INDEXPROPERTY(ID, name ,'IsStatistics') = 0) i ON o.id = i.id
WHERE i.indid IS NULL
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
May 3, 2009 at 4:11 pm
Not using native tools, no.
Basically if you want a table, you have to restore the DB elsewhere and then extract the table.
Litespeed allows you to recover a table from a...
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
May 3, 2009 at 6:21 am
Paul White (5/3/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
May 3, 2009 at 6:13 am
Paul White (5/3/2009)
Just use bcp, SSIS, or SSMS' import/export facility to fast bulk load the damaged tables from the restored filegroup(s).I did mention that before.
Is that really a serious suggestion?
I'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
May 3, 2009 at 5:02 am
RBarryYoung (5/3/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
May 3, 2009 at 3:30 am
Paul White (5/3/2009)
Michael Valentine Jones (5/2/2009)
As I have said all along, the OP will need to use separate databases to be able to restore data independently.
I don't agree. Here...
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
May 3, 2009 at 3:23 am
Paul White (5/1/2009)
And: Darn it - now I have to go and find out what a transportable thingy is in Oracle!
It allows for tablespaces (SQL filegroups) to be moved from...
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
May 2, 2009 at 11:52 am
RBarryYoung (5/1/2009)
The filegroups in a SQL Server database are not transactionaly independent and cannot be made to be so.
Correct. There is no way within the native SQL tools 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
May 2, 2009 at 11:44 am
Post the exec plan?
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
May 2, 2009 at 5:50 am
Viewing 15 posts - 39,331 through 39,345 (of 49,552 total)