Viewing 15 posts - 23,461 through 23,475 (of 49,552 total)
Tom.Thomson (9/17/2011)
GilaMonster (9/17/2011)
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for a few...
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 17, 2011 at 12:17 pm
I'm going to be blunt. Stop guessing.
Syntax of an Update: http://msdn.microsoft.com/en-us/library/ms177523.aspx
Syntax of ISNULL: http://msdn.microsoft.com/en-us/library/ms184325.aspx
Being new is all well and good, but the docs are available and detailed.
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 17, 2011 at 11:35 am
geuncho6 (9/17/2011)
Is there a way to email or call Microsoft and ask?
You can, but they will tell you that other than their partner companies they cannot comment. 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
September 17, 2011 at 10:57 am
You're missing a close bracket. Look at your code, look at mine (just that one line)
There's also a stray bracket just before the where that would throw a syntax error...
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 17, 2011 at 10:54 am
Having never looked at the book, there's no easy way to say.
Stick to the MS press books and the companies MS partners with for practice exams and you should...
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 17, 2011 at 10:45 am
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for a few days. I'm...
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 17, 2011 at 10:38 am
Braindumps are actual copies of the exams. They're the same questions you will get when you take the cert exams. That's why they're not permitted, using them is outright cheating...
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 17, 2011 at 10:24 am
sqlfriends (9/17/2011)
We do have transaction 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 17, 2011 at 10:15 am
Nothing in the suggestion I gave you checks or cares whether the field in the table is null. Open up Books Online (the SQL help files) and read up on...
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 17, 2011 at 8:25 am
One SET in an update, the way your first update was.
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 17, 2011 at 6:23 am
SET
chrWorkDesc = ISNULL(@spDescription, chrWorkDesc ),
chrWorkTitle = ....
Whether that's the best solution is another matter, but it will do what you want.
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 17, 2011 at 6:09 am
Rambling on a bit...
One of the keys to good indexing is to find the fewest number of indexes that support as many of the queries in the database as possible....
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 17, 2011 at 5:45 am
Adding a second table in to disqualify them from trivial plan optimisation...
CREATE TABLE t1 (
ID INT IDENTITY PRIMARY KEY,
Col1 int,
Col2 int
)
go
CREATE TABLE t2 (
ID INT IDENTITY PRIMARY KEY,
t1_ID INT
)
INSERT INTO...
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 17, 2011 at 5:37 am
Tom.Thomson (9/17/2011)
Is it really that flakey? WOuld you get the same three if you fed it the same queries in a different order?
Yes. (though those 3 are actually too...
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 17, 2011 at 5:33 am
Tom.Thomson (9/17/2011)
Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?
I already did, but seeing as I'm 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
September 17, 2011 at 5:04 am
Viewing 15 posts - 23,461 through 23,475 (of 49,552 total)