Viewing 15 posts - 46 through 60 (of 205 total)
That worked. Thanks. Wish I could have found that in BOL.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 1, 2012 at 11:09 am
It worked. Once I copied all tables over to the primary files group I dropped the old tables and then that file, from the DB In the primary file group...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 24, 2012 at 6:25 am
That's my suspicion, that the file group was corrupted somehow and DBCC doesn't catch the problem. My fix for this was to script out each table on that file group...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 21, 2012 at 7:41 am
Bouncing the server made no difference. Still the same error. I am testing with
DBCC ShrinkFile(FG2Data, EmptyFile)
rather than attempting the data load every time.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 20, 2012 at 6:04 am
I have a VB script now, and I could ignore the error, but I'm trying to use the script to decide whether to run the objects in the sequence container,...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
August 20, 2012 at 6:27 am
Prod:
DBINFO @0x6902EF8C
dbi_dbid = 211 dbi_status = 65544 ...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 23, 2012 at 12:03 pm
I ran Ola's original script, with the data purity arg. Fortunately this is a UAT server, so it didn't affect Prod, but because of that the usage is much lower...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 23, 2012 at 9:06 am
I left it to run all weekend and it turns out it only ran 4:41.00. Is CheckDB cumulative, in that whatever it did before is saved and it continues where...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 23, 2012 at 5:16 am
The maintenance job runs:DBCC CHECKDB ([DMART_MSRIPOS]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY
(Ola Hallengren's scripts)
Interactively, I run "DBCC CheckDB(DMART_MSRIPOS)"
If I watch the wait resources, I can see that they are changing, suggesting that...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2012 at 1:59 pm
The waits I have are PageIOLatch_SH and CXPacket, on multiple instances of the command "DBCC Table Check". DM_Exec_Requests show the extact query is being: "DECLARE @BlobEater VARBINARY(8000) SELECT @BlobEater...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2012 at 12:13 pm
The main goal is to remove the login, but I don't want to leave orphans around, so I am trying to remove the users associated with the login from each...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 13, 2012 at 6:33 am
I second GilaMonster. Very large DB files seem to take forever to shrink. I have had them take 2 days, myself. This is a great argument for a clustered index...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 7, 2012 at 10:52 am
It seems to me that you'll need to create a script object in a package to do the job. That will give you the most flexibility. Select the entire record...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 7, 2012 at 10:46 am
I don't think it will do any good to install a SQL 2005 driver on a 2008 server. I can see where that would bite me in the butt.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 2, 2012 at 5:45 am
If I got handed that mess I'd allocate each instance 4G of RAM, and leaving 4G for the OS, that would allow the other node to handle it should there...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 29, 2012 at 12:59 pm
Viewing 15 posts - 46 through 60 (of 205 total)