Viewing 15 posts - 40,891 through 40,905 (of 49,571 total)
Lynn Pettis (2/20/2009)
Bob Hovious (2/20/2009)
I graduated high school in 74.
I graduated 77, so I wasn't so far off.
I don't think I want to give away date of birth. I...
February 20, 2009 at 3:15 pm
Ninja's_RGR'us (2/20/2009)
Would it be prudent to rerun all the backups after the rebuild is done so that any data loss cannot screw something up later on?
Repair or rebuild?
Repair, definitely.
Rebuild is...
February 20, 2009 at 3:14 pm
Access gets corrupt because it's in memory on the client machine. Remember that SQL is a server app. It's running on the server, not the client PC adn it won't...
February 20, 2009 at 3:12 pm
Hmm. I think we're going to need more info.
Please post sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 20, 2009 at 3:09 pm
Shane Miller (2/20/2009)
February 20, 2009 at 2:05 pm
Putts (2/20/2009)
February 20, 2009 at 2:01 pm
Lynn Pettis (2/20/2009)
And you seem to have a slight evil streak in you, too. :w00t:
I run D&D games. It's a required skill. 😀
February 20, 2009 at 1:58 pm
xgcmcbain (2/20/2009)
does sql server do this manually? how do u check this?
sys.dm_db_index_physical_stats
But did not know you can include columns was more concerted of pros and cons of each...
February 20, 2009 at 1:44 pm
angel0in (2/20/2009)
Is data files get currupted if client applications switch off the PC or network connection is broken ?
No.
Corruption in SQL is mostly cause by problems with the IO...
February 20, 2009 at 1:41 pm
brekher (2/20/2009)
Hi,I had started with the first trigger and 1st field but in testing I am updating all rows and need help with the insert.
Because you're not looking at the...
February 20, 2009 at 1:37 pm
JMF (2/20/2009)
I've changed the language of my login, and ran the dbcc command on the MSDB.
That's a lot easier.
Ok, this is not a good situation. You have corruption that...
February 20, 2009 at 1:35 pm
Lynn Pettis (2/20/2009)
Okay, Gail, put down the keyboard and back away slowly.
Never! < Clings to keyboard >
I thought you blacklisted him yesterday? What are you doing? ...
February 20, 2009 at 1:24 pm
Putts (2/20/2009)
SELECT * completes in about a minute and returns 2.9 million rowsSELECT DISTINCT completes in 0 seconds and returns 36 rows.
Run that with STATISTICS TIME on and see how...
February 20, 2009 at 1:23 pm
Half Bubble (2/20/2009)
MS kindly thinks I shouldn't be using EXEC inside a function...
Functions are not allowed to cause side effects. That restriction is checked when the function is created. Since...
February 20, 2009 at 1:10 pm
llokshin (2/20/2009)
Hi, logreader on transactional replication failed with this error
What error?
February 20, 2009 at 1:06 pm
Viewing 15 posts - 40,891 through 40,905 (of 49,571 total)