Viewing 15 posts - 30,796 through 30,810 (of 49,552 total)
If you want to retrieve rows in a particular order, you must put an ORDER BY on the statement that retrieves the data with the appropriate columns listed
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
September 10, 2010 at 6:15 am
samarajithareddy (9/10/2010)
I have to take exam in 15 Days.can u plz send me Training kit of 70-448 which u have prepared &
Exam kits aren't free. You're requesting someone illegally...
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 10, 2010 at 5:09 am
samarajithareddy (9/10/2010)
1.How many questions did we get in 70-448 exam?
It depends. Varies per exam. There's a pool of questions that the exam is constructed from, so two people won't get...
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 10, 2010 at 5:07 am
bbaley (9/9/2010)
I did try this, and it had no effect / same error
SELECT @@VERSION
bbaley (9/9/2010)
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 9, 2010 at 11:15 pm
Andrew-443839 (9/9/2010)
(Option to alter recovery mode to SIMPLE or BULK LOGGED is not preferable).
Why don't you want to switch to bulk logged?
Not wanting to switch to simple I can...
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 9, 2010 at 12:10 pm
IO subsystem problems, same as most other corruption. If I was in your place, I'd be taking a long, hard look at that drive plus all drivers, firmware, etc in...
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 9, 2010 at 12:08 pm
So the SQL Server equivalent would be a char or varchar data type and a check constraint with a whole bunch of OR conditions in it?
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 9, 2010 at 10:02 am
SwayneBell (9/9/2010)
I'm hoping that the prevalence of "LOG_BACKUP" there is a good thing, else pls send Marula as offered 😀
Nope, the opposite.
For 61 databases, the space in the log...
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 9, 2010 at 9:59 am
Steve Jones - Editor (9/9/2010)
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 9, 2010 at 9:42 am
I suggest speak to the user, find out what he wants, then if you don't know how to implement it ask 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
September 9, 2010 at 9:37 am
I can get you some Marula if you want.
Query sys.databases and take a look at the log_reuse_wait_desc for the databases in full recovery. Run DBCC SQLPERF(LogSpace) and see how full...
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 9, 2010 at 9:23 am
Providing he had a backup, had the DB in full recovery and had an unbroken log chain, yes. However that's not a rollback (which is what the question asked)
p.s. 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
September 9, 2010 at 9:13 am
GRANT VIEW DEFINITION ON <object name> TO <user name>
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 9, 2010 at 9:07 am
That won't force it to release memory back to the OS. That will just force it to drop all pages out of the buffer pool (possibly hindering query performance for...
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 9, 2010 at 9:05 am
p.s. I'm not saying DPM is useless. i don't have enough experience with it to say that. Just check and make sure that you can restore what you need 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
September 9, 2010 at 8:32 am
Viewing 15 posts - 30,796 through 30,810 (of 49,552 total)