Viewing 15 posts - 46 through 60 (of 67 total)
Woooow....Noone mentioned guaranteed order via ROW_NUMBER()??
I see that you guys really focus'd hard on matching current and previous rows.
Nice thread though. I found Jeff's article extremely useful for what...
February 13, 2008 at 10:15 pm
Erhm...Forgive me for posting incomplete information. =)
Previously I mentioned restore the corrupted data page...that assumes you backup your log. 😀 Sorry.
Okay, I should leave this post alone. BYE!
February 13, 2008 at 7:10 pm
Tom Leykis (2/13/2008)
Then you would just restore that page from your last backup.
Wait, you're saying this thing has a backup feature? :w00t:
Nice. 😎
I'm saying don't restore the 300GB+ size...
February 13, 2008 at 6:51 pm
reshadit (2/13/2008)
I am no where near the expertise level you guys obviously portray , however in my intermediate DBA experience I have also come to realize when you have...
February 13, 2008 at 6:31 pm
Tom,
I guess manageability has several different meanings. To me, having more files, albeit smaller files...does not make a database more "manageable". That's my opinion anyway.
Being able to...
February 13, 2008 at 6:17 pm
Bah, I missed the whole war between the trip home, dinner, kids bath, and now. 🙂 How come nobody called to tell me?! Oh...right...why would I let you...
February 13, 2008 at 6:00 pm
Come on now, stretch your creativity here! =) Anyone can point at code or fixing code first as the problem or first step.
What if you can't fix the code?...
February 13, 2008 at 3:45 pm
I hope my thoughts can help clarify some of this.
I manage 34,547 production databases across 36 SQL Servers, each server is running about 1,000 databases, we have 3 SAN's to...
February 13, 2008 at 2:55 pm
Is the SQL Server Browser service running and set to automatic startup?
March 16, 2007 at 12:10 pm
did you apply Service Pack 2 for SQL 2005 yet?
It appears you've set everything up correctly.
You stated that it works from one machine to another machine. But that it fails...
March 15, 2007 at 1:33 pm
@Base FLOAT
SET@Base = (SELECT cntr_value FROM sys.dm_os_performance_counters
March 8, 2007 at 11:56 pm
The SQL Server Upgrade Advisor will tell you exactly what will break and what you should start to migrate towards things that will go away in the future.
It will analyze...
March 8, 2007 at 11:08 pm
Quite simply, SQL Server 2005 Standard and Enterprise Edition both take advantage of Multiple processors or Multi-core and Dual-core as you put it as well in the exact same way.
By...
March 8, 2007 at 11:04 pm
Did you try this as well?
GRANT CONTROL ON SERVICE ::ErrorLoggerReceiverService TO SELF
Instead of using...
March 8, 2007 at 8:45 am
Oh... I just re-read your message.
You need to make your sending database trusted.
ALTER DATABASE <DB_NAME> SET TRUSTWORTHY ON
March 8, 2007 at 7:42 am
Viewing 15 posts - 46 through 60 (of 67 total)