Viewing 15 posts - 17,281 through 17,295 (of 49,552 total)
SQL* (8/1/2012)
GilaMonster (8/1/2012)
Limitation probably to keep the size of the index tree down. Wouldn't make any sense to have 8kb index key, the 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
August 1, 2012 at 7:31 am
Patch your SQL instance to the highest service pack available (SP2), consider setting a sensible max server memory and if the dump reoccurs call Customer support and log a case....
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 1, 2012 at 3:52 am
Yes, all pages are 8kb in size.
Limitation probably to keep the size of the index tree down. Wouldn't make any sense to have 8kb index key, the index tree would...
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 1, 2012 at 3:49 am
Please don't create multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1338316-391-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
August 1, 2012 at 2:55 am
Yes, of course it will. That's why we've been saying to restore full then latest diff then all logs since the diff.
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 1, 2012 at 2:53 am
You would restore Saturday's full backup, the Wednesday morning differential, then all log backups since the diff until the point of failure (so 10:30, 11:30, 12:30, 1:30, 2:30, 3:30, 4:30)
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 1, 2012 at 2:43 am
I wrote at a prometric office, but that office is 15 min from my house. If you have to fly to another country to write, the remote option will likely...
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 1, 2012 at 2:23 am
They can, yes. It costs a little more than writing at Prometric, but if you don't have a local office it'll probably work out cheaper. Just make sure you have...
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 1, 2012 at 2:10 am
I am not a licensing expert. Do not take what I say as the absolute truth without verifying with MS licensing (preferably in writing so you have a record)
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 1, 2012 at 2:08 am
You have to disable them in the BIOS, at least for SQL 2008. If the processor is visible to windows, it has to be licensed (SQL). That's the 2008 rules,...
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 1, 2012 at 1:58 am
If your prometric candidate history says you've passed, then you've passed. MS does not mark the knowledge exams, prometric does so they will be the first to know.
The exam doesn'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 1, 2012 at 1:56 am
SQLSACT (7/31/2012)
I've put this together for a "SQL is Slow Now" situation, am I on the right track here?
Two things:
- Firstly cross apply to sys.dm_sql_text for the SQL statement
-...
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 1, 2012 at 1:28 am
It's just an identifier value that's used throughout the system tables. Much like you might create a product table with a productID column and use the productID in related tables.
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 1, 2012 at 1:10 am
If Prometric shows you've passed, then you've passed. Congrats. It's not a 30 day wait, it's up to 30 days, can be a lot less.
I believe there's a 2...
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 1, 2012 at 1:08 am
Those articles cover 64-bit, especially the SQLCAT one.
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 1, 2012 at 1:03 am
Viewing 15 posts - 17,281 through 17,295 (of 49,552 total)