Viewing 15 posts - 28,021 through 28,035 (of 49,552 total)
It shouldn't be broken. If the log backup failed, the log records wouldn't become inactive (because they weren't backed up) and the next log backup should et them (and be...
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
February 1, 2011 at 8:45 am
The mirroring will still exist, it'll be either suspended or disconnected (I expect).
Recovery can be anything from immediate to hours, it depends on the fragmentation in the log, the amount...
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
February 1, 2011 at 8:43 am
parthi-1705 (2/1/2011)
Dave Ballantyne (2/1/2011)
Because its equivalent to
Select * from Sys.sysobjects where id in(Select sysobjects.id from sys.identity_columns)So there is no syntax error
Hi,
Sub-query should need to executed here but why...
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
February 1, 2011 at 7:08 am
Inside a subquery you can reference any column from any table in the subquery, or any table in the main query. The only time you'll get an error is 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
February 1, 2011 at 7:05 am
Kit G (2/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
February 1, 2011 at 7:01 am
Create a temp table, use Insert ... EXEC to insert the output of the procedures into the table, then query the 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
February 1, 2011 at 4:14 am
It's not the default state for one simple reason - it it were, there would be behaviour changes when someone upgraded to SQL 2005. MS doesn't want that, they 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
January 31, 2011 at 10:38 pm
Maybe. The question isn't is there a clustered index (pk is irrelevant for the discussion), but rather is the NC index useful for the query. If it is, there 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
January 31, 2011 at 10:26 pm
vadon97 (1/31/2011)
I appreciate your input. However ...
Then you're one in a million, and I mean that literally.
There's nothing in your initial post to indicate whether it was another...
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
January 31, 2011 at 3:52 pm
Restart SQL is the fastest way. Failover to the mirror and then restart the SQL service on the principal. That's all it'll take.
Drop database, restore, restart mirroring strikes me 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
January 31, 2011 at 3:45 pm
It's the IP address of the machine that originated the connection to SQL.
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
January 31, 2011 at 3:43 pm
vadon97 (1/31/2011)
... so that I can sound like I'm at least familiar with such practices, if I'm granted an interview?
Don't exaggerate your skills. Don't tell then you are experienced...
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
January 31, 2011 at 3:01 pm
Adiga?
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
January 31, 2011 at 2:05 pm
Do you understand how SQL uses the buffer pool for data cache? Need to see where to start explanation from.
Being in the buffer pool and being on disk are not...
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
January 31, 2011 at 2:04 pm
Insert obligatory 'syslogins is deprecated, should not be used for new development, included only for backward compat, will be removed in a future version'
Query sys.server_principals for the logins
SELECT * 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
January 31, 2011 at 12:54 pm
Viewing 15 posts - 28,021 through 28,035 (of 49,552 total)