Viewing 15 posts - 8,896 through 8,910 (of 49,552 total)
TheSQLGuru (5/27/2014)
You also have the dreaded IS NULL OR construct
How did I miss that....
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
May 27, 2014 at 10:40 am
Be careful, that's not necessarily going to work under concurrent calls if it's a manual 'identity' column (two queries could get the same max value)
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
May 27, 2014 at 7:12 am
+ CAST(CASE WHEN PER.[GENDER] = 'M' THEN '1'
WHEN PER.[GENDER] = 'F' THEN '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
May 27, 2014 at 5:42 am
That's Express edition. Express doesn't come with SQL Agent. Only the paid versions of SQL come with agent.
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
May 27, 2014 at 4:15 am
I'm running 2014, 2012 and 2008 R2 on a Win 7 box. They all work fine.
Could be he specified system DB files in the same place as the earlier version...
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
May 27, 2014 at 4:09 am
Please note: 4 year old (solved) thread.
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
May 27, 2014 at 4:06 am
Then no idea. Would have to repo and diagnose live to be able to say anything useful.
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
May 27, 2014 at 3:31 am
http://www.microsoft.com/learning/en-gb/retired-certification-exams.aspx
Being withdrawn on 31 July 2014
70-433: TS: Microsoft SQL Server 2008, Database Development
70-450: PRO: Microsoft SQL Server 2008, Designing, Optimizing and Maintaining a Database Administrative Solution
70-451: PRO: Microsoft SQL Server...
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
May 27, 2014 at 3:15 am
Hard to say for sure without being able to investigate...
Online index rebuilds aren't online. They're mostly online. They need to take schema locks at two points, right at the beginning...
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
May 27, 2014 at 3:01 am
mailtonoorul (5/27/2014)
whether it is mandatory that table should be in 3rd normal form?whether it can be in 2nd normal form?
Tom and Jeff both answered that.
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
May 27, 2014 at 2:42 am
I need a new laptop myself, but not even considering a surface.
I have an iPad which serves the tablet role just fine. My requirements for a laptop include being able...
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
May 27, 2014 at 2:31 am
Why do you want to avoid the left joins?
Why are you using hints which allow incorrect results?
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
May 27, 2014 at 2:24 am
Please post unrelated questions in a new thread
And forgive me if this sounds insulting, but do you do any research at all before asking here? If the answer to that...
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
May 27, 2014 at 2:17 am
Yup, that sounds about right.
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
May 27, 2014 at 2:14 am
sql-lover (5/26/2014)
SQL Server does not hold statistics for table variables so row count is always 1.
Not actually true.
A good rule of thumb is picking table variables for small sets, 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
May 27, 2014 at 2:14 am
Viewing 15 posts - 8,896 through 8,910 (of 49,552 total)