Viewing 15 posts - 29,926 through 29,940 (of 49,552 total)
GSquared (10/15/2010)
On the other hand, someone can be a very skilled DBA without being a skiller performance tuning expert. "DBA" covers WAY too much scope these days.
That's why...
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
October 15, 2010 at 11:39 am
GSquared (10/15/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
October 15, 2010 at 11:35 am
And just when I thought the situation at That Client couldn't get any worse....
<headdesk><headdesk><headdesk><headdesk>
(No, I'm not going into details, it's a little too sensitive a topic for that. Just.... :crazy:)
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
October 15, 2010 at 11:30 am
drew.allen (10/15/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
October 15, 2010 at 11:18 am
A list of questions is not going to get you through an interview. A competent interviewer can tell the difference between someone who has memorised answers and who knows the...
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
October 15, 2010 at 9:25 am
nvarchar? String conversions are the nastiest way to work with dates. Also yours will give -ve numbers for the days between christmas and new year
I think this works...
DECLARE @DateToCheck...
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
October 15, 2010 at 9:21 am
Boring 😀
DECLARE @test TABLE (star VARCHAR(20));
INSERT INTO @test (star)
VALUES ('Sol'),('Proxima Centauri'),('Rigel'),('Sirius'), ('Barnard''s star')
SELECT star FROM @test;
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
October 15, 2010 at 9:12 am
SKYBVI (10/15/2010)
Does that mean identity column??
No. I mean that if you use the Row_Number to add a 'sequence' column all that does for you is gives you a column 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
October 15, 2010 at 8:39 am
SKYBVI (10/15/2010)
I will now try row_number.
Don't. It still won't enforce order in the table or order when selected. It'll just give you a convenient column to 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
October 15, 2010 at 8:20 am
Steve Jones - SSC Editor (10/15/2010)
Who throws a can of soda out of a car? That's insane.
A little brat sitting in the back seat and not being supervised 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
October 15, 2010 at 8:15 am
SKYBVI (10/15/2010)
The best practices for system databases is that it is not necessary to backup the tempdb database as it is rebuilt each time SQL Server starts.
TempDB can't be backed...
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
October 15, 2010 at 8:05 am
Alvin Ramard (10/15/2010)
Brandie Tarvin (10/15/2010)
george sibbald (10/15/2010)
As for the can of soda, I'll be more accurate next time. 🙂
That was you? Shame!
And here I thought it was the guy from...
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
October 15, 2010 at 8:01 am
Performance tuning? I've had senior DBA candidates who couldn't tell me two types of SQL Server backups.
If I found a candidate that didn't know DMVs because he used 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
October 15, 2010 at 7:56 am
sachinsoni84 (10/15/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
October 15, 2010 at 7:51 am
george sibbald (10/15/2010)
GilaMonster (10/14/2010)
CirquedeSQLeil (10/14/2010)
That's quality entertainment
Yup.
Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway...
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
October 15, 2010 at 7:13 am
Viewing 15 posts - 29,926 through 29,940 (of 49,552 total)