Viewing 15 posts - 2,506 through 2,520 (of 3,011 total)
JonJon (1/30/2008)
Weeks in a month for me mean...Number of weeks in a month.
Example: Week 1, Week 2, Week 3, Week 4
New Month:
Week 1 to Week 4
That tells absolutely nothing about...
January 30, 2008 at 12:25 pm
John Mitchell (1/30/2008)
But you can't divide into four filegroups anyway, since one of your tables is 39GB... unless you partition the table.John
He didn't say he was dividing into 4 filegroups.
He...
January 30, 2008 at 12:16 pm
AlexSQLForums (1/30/2008)
Michael Valentine Jones (1/29/2008)
January 30, 2008 at 12:12 pm
It is rude to post the same question multiple times.
January 29, 2008 at 9:53 pm
It is rude to post the same question multiple times:
January 29, 2008 at 9:42 pm
It is rude to post the same question multiple times:
January 29, 2008 at 9:41 pm
Even if your data files are on different arrays, the backup speed will also be limited by the speed that it can write the backup file. It is fairly...
January 29, 2008 at 8:50 pm
Why do you think it will backup faster if you have 10 datafiles, instead of one?
January 29, 2008 at 8:32 pm
I think you need to provide a definition of what you mean by "Weeks in a month" before anyone can really help you with code to produce that. "Weeks...
January 29, 2008 at 8:14 pm
If you are trying to rename the local SQL Server, this is the way:
exec master.dbo.sp_dropserver 'CurrentServerName'
exec master.dbo.sp_addserver 'NewServerName','local'
January 25, 2008 at 3:53 pm
Remember that in SQL Server you are not entering dates but datetimes. This means that you must alway consider the time component in any query.
When you want data for...
January 25, 2008 at 3:42 pm
When you want data from a date range, it is usually better to do the selection in the form of:
where MyDate >= @StartDatetime and MyDate < @EndDatetime
This will allow the...
January 25, 2008 at 1:34 pm
I don't think you can call those statements anything except wrong.
January 25, 2008 at 12:50 pm
Viewing 15 posts - 2,506 through 2,520 (of 3,011 total)