Viewing 15 posts - 40,021 through 40,035 (of 49,571 total)
Chris Morris (4/3/2009)
No need, Barry - somehow in my misspent youth I managed to "satisfy the requirements" for a PhD. GF bullies me to use the title.
So we need to...
April 3, 2009 at 7:38 am
josephptran2002 (4/3/2009)
But I don't know how to post the table with sample data in this forum. That why I am asking you to show me how?
I just showed you...
April 3, 2009 at 7:36 am
I don't understand what you're struggling with.
To post a sample table, paste the CREATE table statement into the edit window, like this:
CREATE TABLE [dbo].[LargeTable](
[ID] [int] NULL,
[SomeString] [char](6) NULL,
[RandomDate] [datetime] NULL,
[Big]...
April 3, 2009 at 3:12 am
Sleeping just means not currently running queries. While you can kill them, doing so may well cause problems for the applications if the assume that the connection will remain open.
Why...
April 3, 2009 at 2:54 am
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...
April 2, 2009 at 4:15 pm
bladerunner148 (4/2/2009)
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...
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?
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....
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),
...
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,...
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...
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...
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...
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...
April 2, 2009 at 11:25 am
Viewing 15 posts - 40,021 through 40,035 (of 49,571 total)