Viewing 15 posts - 37,891 through 37,905 (of 49,552 total)
river (7/3/2009)
Can you please validate master?
Looks fine.
I don't know why you're calling me 'master' though. Honestly, I'd prefer if you didn't use that, my name is at the bottom ad...
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 3, 2009 at 1:13 pm
Don't worry. I've spelt Florian's name wrong in a published article and Grant's surname wrong in a post on the MVP newsgroups :blush:
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 3, 2009 at 9:10 am
You still need to do an update stats. Rebuilding the indexes will update stats on those indexes. It won't update column statistics that aren't associated with an index though. Like...
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 3, 2009 at 9:02 am
You laugh. I was speaking with someone recently and he said that he and his team do some SQL development, but nothing complex, no joins or anything.
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 3, 2009 at 8:56 am
I was hoping that Paul would comment on this, but he's on vacation for a month.
If the dropping of the stats doesn't work (and apparently it doesn't, seeing as you...
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 3, 2009 at 8:35 am
Just got some clarification on this.
SQL Enterprise can be installed on Vista. It is not, however, a supported configuration. This means that should you call customer support with a problem...
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 3, 2009 at 8:31 am
vitesh.bhana (7/3/2009)
If only they had added some sharks...
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 3, 2009 at 8:21 am
river (7/3/2009)
UPDATE STATISTICS table_name WITH FULLSCANAll the statistics of this table will be updated with the option FullScan.
Correct
But , for instance i...
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 3, 2009 at 8:18 am
latingntlman (7/3/2009)
Bruce, your suggestions "convert(varchar" won't work because it's a text field, so the field needs to be parsed to remove the spaces and time after the date. Then...
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 3, 2009 at 6:57 am
This should give you the idea
DECLARE @DateInString varchar(20)
SET @DateInString = '7/2/2009 4:18:25 PM'
SELECT CAST(@DateInString AS DATETIME)
SELECT DATEADD(dd,datediff(dd,0,@DateInString),0)
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 3, 2009 at 6:56 am
river (7/3/2009)
Shoud i update statistics for all the tables in my databases and all indexes?
As I said, if you check books online, you'll see that you can either update...
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 3, 2009 at 6:51 am
I would suggest that you first get used to SQL's native locking mode, understand how it works, when there are problems with it and why. Snapshot isolation is not 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
July 3, 2009 at 6:08 am
Fairly often on holidays the Question of the day will relate to the holiday, not to SQL. I've seen halloween-related questions, christmas-related questions, etc. It's just a bit of fun.
Those...
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 3, 2009 at 6:01 am
SQL by default uses locks for transaction isolation, while Oracle uses a form of row-versions.
In SQL, if you issue an update within a transaction, the locks taken by that update...
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 3, 2009 at 5:57 am
river (7/3/2009)
UPDATE STATISTICS table_name WITH FULLSCAN
Should i update only tables statistics? or should i update every table and every...
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 3, 2009 at 5:49 am
Viewing 15 posts - 37,891 through 37,905 (of 49,552 total)