Viewing 15 posts - 36,601 through 36,615 (of 49,552 total)
igngua (9/2/2009)
it says syntax error.
Brackets around the select shouldn't be there.
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 2, 2009 at 2:48 pm
igngua (9/2/2009)
I dont know why this trigger aint working.
What do you mean by 'not working'? What's it not doing that it should be?
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 2, 2009 at 2:37 pm
Please read through this - http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 2, 2009 at 2:11 pm
SQL Guy (9/1/2009)
Is there anything we can do to reduce locking time or completely eliminate it ? Are there any techniques, tricks to do this ?
Maybe.
Can you read through this...
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 2, 2009 at 2:03 pm
dsdeming (9/2/2009)
Doesn't selecting into a temp table (SELECT * INTO #a FROM whatever) lock tempdb for the duration of the operation?
That used to be true, somewhere around version 6.5.
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 2, 2009 at 2:01 pm
Jack Corbett (9/2/2009)
Hey, I stumped Gail! Wasn't intentional but when TEXT/NTEXT/IMAGE was mentioned I wondered about Filestream.
Looks like the answer is 'No'
-- Document is a varbinary(max) Filestream column
Create Index...
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 2, 2009 at 1:51 pm
Can you also post the table definitions and index definitions?
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 2, 2009 at 1:21 pm
Terry Grignon (9/2/2009)
I've seen mention of 'The number of data files within a single filegroup should equal to the number of CPU cores.'
That advice is for TempDB and only...
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 2, 2009 at 1:16 pm
There are quite a few site issues lately, timeouts, errors on posting. Some people will just retry and retry without checking to see if the post went through.
Yes, you 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
September 2, 2009 at 9:43 am
That said, shrinking the DB on a regular basis is not a good idea. Once you've got the size under control rather don't shrink the file regularly, just free up...
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 2, 2009 at 9:40 am
Roger Abram (9/2/2009)
Thank you. What would the best command to shrink the database?
DBCC SHRINKFILE
look up the full syntax in Books Online
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 2, 2009 at 9:29 am
fox1977 (9/2/2009)
Do i need anything around the database name? brackets or anything similar?
Only if the database name starts with a non-alpha character or has a space or other disallowed...
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 2, 2009 at 9:27 am
Roger Abram (9/2/2009)
If I truncate tables in that database, will that automatically decrease the size of the MDF file?
No
Or is there something I need to do afterwards?
Shrink...
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 2, 2009 at 9:06 am
Grant Fritchey (9/2/2009)
Excellent. Thanks. But now the follow-up. If you could only pick one or two disk counters to watch, what would they be?
The three I usually use are Avg...
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 2, 2009 at 8:56 am
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.Thanks. I was told the max number was 435. I only saw 410.
Mine...
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 2, 2009 at 8:51 am
Viewing 15 posts - 36,601 through 36,615 (of 49,552 total)