Viewing 15 posts - 10,666 through 10,680 (of 14,953 total)
I'm a little late to this thread, since I was sick in bed all day yesterday. But, just to get my post-count up, I'm going to post this. 🙂
After...
March 4, 2009 at 8:01 am
When someone is intentionally offensive, I point it out to Steve, who is the editor/moderator/etc., for the site, and he takes care of it.
March 4, 2009 at 7:43 am
We're currently working on plans to finally retire our last SQL 2000 instance. The main database on it will no longer be necessary to the business by about mid-month,...
March 4, 2009 at 7:40 am
anbillava (3/2/2009)
so u guys are tellign its hard to acheive by reading some docs
It's not just a question of reading some docs. There are a LOT of aspects to...
March 4, 2009 at 7:22 am
Lynn Pettis (3/4/2009)
And then you have this. I don't think the desert is big enough to hide in anymore.And, am I still Saint?
The link doesn't appear to go anywhere....
March 4, 2009 at 7:04 am
Sergiy (3/2/2009)
GSquared (3/2/2009)
Well, if all the queries behave the same on all the indexes, then it doesn't really matter which one you use.
It does matter.
I did not see here tests...
March 2, 2009 at 2:20 pm
That error usually comes up when either the file in question is already in the middle of being shrunk, or when a prior shrink command on it was aborted.
From an...
March 2, 2009 at 2:15 pm
Something like this:
declare @Date datetime;
select @Date = '3/5/09';
select
case datepart(weekday, @Date)
when 2 then dateadd(week, -1, @Date)
else dateadd(day, -1 * datepart(weekday, @Date), @Date) + 2
end as SDate,
case datepart(weekday, @Date)
when 2 then...
March 2, 2009 at 12:50 pm
If the database is in full recovery mode, the easiest way to find out exactly what's going on is to use a log parser on the transaction log. ApexSQL...
March 2, 2009 at 11:51 am
You could fix the table by creating a temporary table, inserting the data into it, then dropping the real table and re-creating it with the new PK, and then inserting...
March 2, 2009 at 11:41 am
It's a big subject. I highly recommend hiring someone who does that kind of thing for a living. There are companies that do that.
March 2, 2009 at 9:55 am
I guess the stuff I've thought of on it just doesn't add up that way.
March 2, 2009 at 9:47 am
Build a table of allowed values. Use OpenRowset to query the Excel file, join it to the table of allowed values in the query. Very simple.
March 2, 2009 at 9:45 am
It means the registry key for that is being rolled back/reset. Make sure the registry is saved correctly, doesn't have any corruption, etc. Which mode SQL Server uses...
March 2, 2009 at 9:23 am
It's stored in the Windows registry. Here's an article on dealing with the registry from within SQL:
http://www.sqlservercentral.com/articles/Administration/3092/
March 2, 2009 at 9:22 am
Viewing 15 posts - 10,666 through 10,680 (of 14,953 total)