Viewing 15 posts - 19,921 through 19,935 (of 49,552 total)
ddafunk (3/5/2012)
but will you not advise me to get a cert to atleast show i do have knowledge of what i can do?
No, I won't. A cert requires experience...
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
March 5, 2012 at 7:11 am
A certification with no experience is of little to no value. Put certs and 0 experience on a CV and it's about as good as just 0 experience.
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
March 5, 2012 at 6:53 am
ddafunk (3/5/2012)
another question how many exams would you advise me to take in order to have a basic knowledge
None. The certification exams expect and require a certain amount of experience...
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
March 5, 2012 at 6:38 am
Your syntax is wrong.
RESTORE DATABASE <database name> FROM DISK = <backup location>
WITH STANDBY = <Undo file location>
and
RESTORE LOG <database name> FROM DISK = <backup location>
WITH STANDBY = <Undo file location>
p.s....
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
March 5, 2012 at 4:03 am
Transaction logs are not audit logs, they don't contain a lot of the information that an audit would need (login name, host name, etc). They are there for database integrity...
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
March 5, 2012 at 3:21 am
Just about none. It's a brute-force instrument, wipes every plan from the cache and forces SQL to recompile them all. It can fix parameter sniffing problems or other cases of...
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
March 5, 2012 at 3:19 am
32 bit or 64 bit?
How much memory on the server?
What's SQL max server memory set 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
March 5, 2012 at 3:17 am
Order By is only valid in the outer-most query (the one that queries the CTE) unless a row-limiting TOP is in place.
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
March 5, 2012 at 3:16 am
A procedure's signature is its parameters and output. So say I have a procedure that accepts an int parameter and returns a single resultset of a particular form. 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
March 5, 2012 at 3:02 am
Kennedy.Parker (3/4/2012)
"No" because there is some kind of conversion of data pages when attaching or restoring to a more current release?
This
A database attached to a SQL 2008 instance is a...
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
March 5, 2012 at 3:01 am
lfc8ynwa (3/4/2012)
Not looking for the answers, I want to figure...
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
March 5, 2012 at 3:00 am
fanzhouqi (3/4/2012)
GilaMonster (3/4/2012)
Here's the link to the amazon page: http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/ref=sr_1_1?ie=UTF8&qid=1330881644&sr=8-1. It's only $35 and it's excellent value for money.
i know but i’m in china. buy from amazon is not convenient...
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
March 5, 2012 at 2:56 am
What you have there is a partial cross join. If there are duplicate (or more) userIDs on both sides, the resultant row count is much larger than you might expect.
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
March 4, 2012 at 4:06 pm
kilkenny (2/27/2012)
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
March 4, 2012 at 11:38 am
Here's the link to the amazon page: http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/ref=sr_1_1?ie=UTF8&qid=1330881644&sr=8-1. It's only $35 and it's excellent value for money.
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
March 4, 2012 at 10:21 am
Viewing 15 posts - 19,921 through 19,935 (of 49,552 total)