Viewing 15 posts - 24,691 through 24,705 (of 49,552 total)
Grant Fritchey (7/26/2011)
Gianluca Sartori (7/26/2011)
Grant Fritchey (7/26/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
July 26, 2011 at 6:06 am
Ninja's_RGR'us (7/26/2011)
GilaMonster (7/26/2011)
Once more with feeling anybody?http://www.sqlservercentral.com/Forums/Topic1148024-1291-1.aspx
Maybe it's time to add your mvp title back to your sig! 😉
Actually not a bad idea. I do at SQLTeam and it seems...
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
July 26, 2011 at 6:06 am
Once more with feeling anybody?
http://www.sqlservercentral.com/Forums/Topic1148024-1291-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
July 26, 2011 at 5:49 am
Well if the exam is retired, then you can't write it so you can't get certified on SQL 2005 any longer.
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
July 26, 2011 at 5:21 am
insert into #TempB
select SOFTWRARE_ID,LOGIN_ID from #TempA
GROUP BY SOFTWRARE_ID
HAVING COUNT(LOGIN_ID)>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
July 26, 2011 at 4:27 am
Tables by definition do not have a order for the rows in them, they are an unordered set of rows. There's no such thing as 'row 1' in a table....
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
July 26, 2011 at 4:23 am
M.Kahn (7/26/2011)
This is professional site joke not accepts here. Can you answer his question ? so answer in nice way. Otherwise backoff.
Watch the attitude....
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
July 26, 2011 at 3:51 am
Do you have any persistent Enterprise-only features in your database?
Use sys.dm_db_persisted_sku_features to see. If you do, you won't be able to restore to standard or lower unless you remove them.
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
July 26, 2011 at 2:48 am
Snapshot as in...
1) database snapshot?
2) Replication snapshot?
3) SAN-based snapshot backup?
4) Snapshot isolation level?
5) something else?
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
July 26, 2011 at 1:49 am
Tables don't have an order. No such concept. Tables are an unordered set of rows. If you want an order to the returned rows, you must use an Order By...
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
July 26, 2011 at 1:45 am
People have written entire books on that. Literally.
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
July 26, 2011 at 1:44 am
And the error message is....????
It's possible providing you have no persistent Enterprise-only features in use in the DB.
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
July 26, 2011 at 1:42 am
Two options then:
1) rebuild master (it's an option on the installer), then restore the backup of master and msdb and, if you had any custom stuff, model.
2) Get a copy...
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
July 25, 2011 at 4:38 pm
george sibbald (7/25/2011)
GilaMonster (7/25/2011)
TRaceflag 3608Start the SQL Server from the command line in single user, restricted more and with that traceflag
SQLServr.exe -m -f -T3608
I don't believe that will work Gail....
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
July 25, 2011 at 4:35 pm
SQLRNNR (7/25/2011)
GilaMonster (7/25/2011)
mtillman-921105 (7/25/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
July 25, 2011 at 12:08 pm
Viewing 15 posts - 24,691 through 24,705 (of 49,552 total)