Viewing 15 posts - 46 through 60 (of 98 total)
You need expert help - try PM to Gail? Mainly don't panic and do anything in a hurry.
There is more general advice here http://www.sql-server-pro.com/dbcc-checkdb.html about what else to check and...
September 18, 2009 at 4:58 pm
rob.lobbe (9/15/2009)
This works if you are the ONLY one using the database.Running in a production system you can't just go about changing the recovery model.
Not so sure about it.
MSDN (
September 15, 2009 at 6:01 pm
gah (9/10/2009)
rf44 (9/10/2009)
This is one of the most arrogant, presumptuous and unfounded assertion I ever read.Strong words indeed...would you care to elaborate....maybe some examples.
..
Perhaps not...that would turn into Religious Wars...
September 10, 2009 at 5:14 pm
If you have the urge to migrate SQL Server objects to MS Access, the best thing to do is to lay down in a locked dark room until the...
September 2, 2009 at 7:50 am
anithagovindarajalu (9/1/2009)
Hi,Thanks for your replies. But I need to perform for multiple tables in single package.
Thanks,
Anitha
Is this not off-topic? Should be SSIS not BI ??
At any...
September 2, 2009 at 4:28 am
Michael Oberhardt (7/14/2008)
August 7, 2009 at 7:57 am
When I became the involuntary DBA, I had a very nebulous idea about the difference between SIMPLE & FULL recovery modes. I inherited 5 servers where agent jobs were backing...
August 7, 2009 at 7:47 am
Thank you - wonderful initiative to help us see stuff that may make a real difference in troubleshooting performance issues.
See elsewhere how Hugo Kornelis, armed with this knowledge, helped me...
August 3, 2009 at 5:07 pm
Jeff Moden (9/13/2008)
Jack Corbett (9/13/2008)
August 3, 2009 at 12:38 am
Jack Corbett (7/31/2009)
The only problem with LTRIM(RTRIM(column)) in comparison (WHERE or JOIN) clauses it that you no longer give the optimizer the option to use an index seek, the best...
August 3, 2009 at 12:29 am
Good work. Most certainly there are cases when a string - or bigint - needs to be constructed this way.
Otherwise, of course, just the 112 format mask for CONVERT will...
July 31, 2009 at 5:47 am
Eswin (7/21/2009)
First:
In database property set query time out to 0, It's default vaule is 600.
Second:
In your connection string add "Connection Timeout = 0"
Third:
When you executing your stored procedure...
July 22, 2009 at 8:50 am
Here we go again . . . to complete the picture above:
on our Win2003 Server Standard 32-bit the memory is limited to 4GB.
Therefore the above clarification becomes : MSSQL2005 Standard...
July 21, 2009 at 12:33 am
mmaharaj (7/20/2009)
I am running SQL Server Enterpise Edition.The value appears as 2147483647 MB, in the memory tab as Maximum server memory.
See my own Edit above ... Standard Ed is not...
July 20, 2009 at 9:16 am
mmaharaj (7/20/2009)
I have another question though, all my sql2k5 servers seem to have this set as the limit by default.
AWE is not enabled...
July 20, 2009 at 8:51 am
Viewing 15 posts - 46 through 60 (of 98 total)