Viewing 15 posts - 45,331 through 45,345 (of 49,552 total)
That error means that the last backup that was restored to the database was restored WITH RECOVERY. With recovery means that transactions are rolled forward and back as necessary and...
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 31, 2008 at 2:03 am
Buy the self-paced training kits for the different exams. They are quite good.
Brain dumps are cheating and, if you are caught using them, all of your certifications will be revoked,...
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 31, 2008 at 2:00 am
You may want to set the max memory lower. Maybe 3 GB. SQL's been told that it may use up to 3.5 GB and it will do that, even 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
July 31, 2008 at 1:57 am
Michael Earl (7/30/2008)
NOLOCK in particular can result in missed or even duplicated data as your query reads through the pages.
And readpast can skip rows by definition, since it 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
July 30, 2008 at 12:40 pm
Just be aware that in SQL 2000 decrypting encrypted stored procedures was a fairly trivial operation.
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 30, 2008 at 12:14 pm
Rather stay away from any form of hints. If you have blocking problems look at optimising the queries that are causing the blocking, rather than hiding the symptoms with locking...
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 30, 2008 at 12:11 pm
Sandy (7/30/2008)
(Still i wants to know should i create index or not on the foreign key column.....he he he..lolz....:))
As I said several times in this thread, probably but test 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
July 30, 2008 at 12:03 pm
Michael Earl (7/30/2008)
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 30, 2008 at 10:00 am
Sure, but don't consider them the official word from Microsoft, as that is not the 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
July 30, 2008 at 9:38 am
Sandy (7/30/2008)
the word "often" makes me more...
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 30, 2008 at 9:32 am
I doubt it. Openrowset is a function to pull data into SQL in a table format. The default trace runs to disk.
I've never seen this on my servers and...
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 30, 2008 at 9:30 am
Sandy (7/30/2008)
Please Check this:
Those aren't official Microsoft Standards, they're blog posts by two MVPs.
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 30, 2008 at 9:29 am
Have you tried downloading RC0? It's the latest publicly available pre-release version. AFAIK, the CTPs have hardcoded expiry dates in them. It makes sense as they are just for testing.
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 30, 2008 at 9:02 am
To be a bit more specific, when I'm considering indexes, what I will do is create the index that I think may be useful (perhaps one on a foreign key),...
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 30, 2008 at 8:54 am
Sandy (7/30/2008)
Gail,If you will become the DB designer then which model do you prefer??
I mean to say...a Covering Index on the table OR a Index on Foreign Key column??
Depends. Maybe...
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 30, 2008 at 8:45 am
Viewing 15 posts - 45,331 through 45,345 (of 49,552 total)