Viewing 15 posts - 15,376 through 15,390 (of 26,486 total)
May I suggest that you start running scheduled T-LOG backups? This will help manage the size of the transaction log and make database recovery a bit easier.
June 11, 2010 at 9:15 am
Our AV program is set to exclude the data drives and only scans out-bound files. Haven't had any performance issues.
June 11, 2010 at 9:11 am
I'm confused. Please provide the DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data (as a series of INSERT INTO statements) for each table (data should not be...
June 11, 2010 at 9:10 am
Problem, we can't see what you see from where we sit. We don't know how your data is stored, nor do we know the structure of the table involved....
June 11, 2010 at 9:06 am
Can't help with the crashes, but I did want to respond about the SP 2 comment.
In the information returned by @ @VERSION, SP 2 refers to the OS, not SQL...
June 11, 2010 at 9:03 am
Nevermind, Gail responded before I could find the reference below.
You might, might, be able to attempt a tail log backup of the database. Check this out: http://msdn.microsoft.com/en-us/library/ms179314.aspx.
Other than that,...
June 11, 2010 at 8:48 am
GilaMonster (6/11/2010)
CirquedeSQLeil (6/11/2010)
Lynn Pettis (6/11/2010)
Some people really need to RTFM, or in this case, BOL.Yup - or at least finish reading that book from which the example was taken.
I hope...
June 11, 2010 at 8:36 am
Try this:
select
ma.*
from
#Model_Aggregate ma
left outer join #Toman_Aggregate ta
on (ma.AggID = ta.AggID
...
June 11, 2010 at 8:27 am
You are only showing us part of the problem. Please provide the entire query, and if it is a stored procedure, the actual procedure.
June 11, 2010 at 8:05 am
Some people really need to RTFM, or in this case, BOL.
June 11, 2010 at 8:03 am
davidshephard (6/11/2010)
USE [Galactic]
GO
DECLARE @return_value int
EXEC @return_value =...
June 11, 2010 at 7:59 am
CirquedeSQLeil (6/10/2010)
Lynn Pettis (6/10/2010)
Here, however, is my two-cents.
Soccer is...
June 10, 2010 at 2:36 pm
1) Each nvarchar column takes twice as much space as the cooresponding varchar/text column.
2) Due to increased record size, fewer records per page.
3) Any indexes on the nvarchar columns or...
June 10, 2010 at 2:17 pm
sudhakar0683 (6/10/2010)
hi boss i mean to say lite speed is a third party tool but now microsoft has been taken that tool and inbuilt in sql server 2008
As others have...
June 10, 2010 at 2:07 pm
I'm not going to try and answer many of the questions, comments, or concerns regarding soccer (football everywhere else in the world).
Here, however, is my two-cents.
Soccer is a simple game...
June 10, 2010 at 1:58 pm
Viewing 15 posts - 15,376 through 15,390 (of 26,486 total)