Viewing 15 posts - 40,006 through 40,020 (of 49,552 total)
bladerunner148 (4/2/2009)
Hi SSCChampion,
No one here by that name
AutoGrowth : By 1MB, unrestricted growth
That's a stupid autogrow setting for a 4 GB file. Try 100MB. A lot more reasonable
Could not allocate...
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
April 2, 2009 at 4:15 pm
bladerunner148 (4/2/2009)
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
April 2, 2009 at 3:51 pm
josephptran2002 (4/2/2009)
How can I locate the default of specific column in the table?
In the table designer click on the column. At the bottom of the screen is a list of...
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
April 2, 2009 at 3:34 pm
Perhaps Latin would work better here. Or maybe Gaelic. I'm even contemplating trying Adronato.
http://www.sqlservercentral.com/Forums/Topic688319-146-1.aspx
Any suggestions on making 'last entries from previous error log' clearer?
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
April 2, 2009 at 2:24 pm
ebenraja (4/2/2009)
Then the server got restarted when i ran the check table command for a table and the error log again is as follows
Again that is the startup messages....
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
April 2, 2009 at 2:20 pm
josephptran2002(4/2/2009)
would you please tell me how to create a table with the sample data in table?
He already has.
Florian Reischl (4/2/2009)
Better way for this:
CREATE TABLE #BO
(
BODDS VARCHAR(10),
...
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
April 2, 2009 at 2:01 pm
It's because the shutdown was unexpected and sudden. SQL didn't have time (or warning) to cleanly shut the databases down (rollback uncommitted transactions, write dirty pages to disk) before terminating,...
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
April 2, 2009 at 2:00 pm
josephptran2002 (4/2/2009)
How can I stop the date that have been entering automatically in row?
Remove the default that's on the column.
In management studio, design the table (object explorer, right click 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
April 2, 2009 at 1:49 pm
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in 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
April 2, 2009 at 1:45 pm
Wait.
Unless there's a bigger problem, SQL's busy recovering your database. If you check the log you should see entries like this.
Recovery of database MyDB is 42% complete (phase 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
April 2, 2009 at 1:45 pm
RESTORE DATABASE database PAGE='1:189, 1:190, 1:191'
FROM DISK='path'
GO
The maximum number of pages that may be restored in a single restore statement is 1000. See the page in Books Online titled "Performing...
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
April 2, 2009 at 11:25 am
kevinwinters (4/2/2009)
Foreign ground with me - would I actualy start a query with ";with"?
Yup, you would. It's the syntax for a common table expression (CTE), essentially a temporary view. 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
April 2, 2009 at 9:56 am
David Burrows (4/2/2009)
I posted a brief answer on the second just for the hell of it :w00t:I await a good flaming now :Whistling:
Likewise.
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
April 2, 2009 at 9:55 am
jsanborn (4/1/2009)
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
April 2, 2009 at 9:50 am
Anukul (4/2/2009)
Can you in anyway help me in writing the Sync program or that complex SSIS package?
I've just finished doing one for a client. It took me an entire week...
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
April 2, 2009 at 9:45 am
Viewing 15 posts - 40,006 through 40,020 (of 49,552 total)