Viewing 15 posts - 2,836 through 2,850 (of 3,061 total)
How about looking at the size of your transaction logs? all the ones showing no acitivity should be of the same size, the last one showing something else would...
October 16, 2008 at 4:44 am
Okay... lets try to get to the bottom line on this stuff.
You should create a PK when you want to have RI enforced.
If you want to enforce uniqueness an Unique...
October 16, 2008 at 4:39 am
...so you want the space back after dropping a column?
Just reorganize e.g. move the affected table.
In regards to all those posts talking abour shinking the database... pals/gals... what has possesed...
October 16, 2008 at 4:33 am
I see... sort of home-made replication, huh?
I assume you have already figured it our you would probably need two jobs... one on the source machine and one on the target...
October 16, 2008 at 2:38 am
Steve --
Have you noticed that in a weird way you are supporting my position?
The parallel universe you are describing where college professors know what they are doing, upper management...
October 16, 2008 at 2:35 am
smunson (10/15/2008)If I had my way, an organization would NEVER have ANY developers who weren't capable of good, solid, DBA skills, at least from a performance and database design perspective,...
October 15, 2008 at 11:01 am
Not that weird, I'm with Jason... somebody got rid of it.
Well... not all are bad news, you can take this situation as an opportunity to test your backup/recover strategy 🙂
October 15, 2008 at 10:48 am
doobya (10/15/2008)
The application developer should be the DBA of his applications' databases.Separation of roles results in low quality results.
Integration is the route to high quality and efficiency.
:w00t: my eyes!... my...
October 15, 2008 at 10:35 am
Just in case it was a two parts question... no, altering MODEL tables wouldn't stop your user from working.
October 14, 2008 at 8:49 am
Jeff Moden for President!!!
You have my vote Jeff, I do agree.
October 14, 2008 at 5:08 am
Wilfred van Dijk (10/14/2008)
... do I need to rebuild the index after truncating the table to get the index size under control?...
If you truncate the table, SQL marks the table...
October 14, 2008 at 4:52 am
Not sure why you want to work that hard to solve something is already solved, wouldn't be easier to schedule a job or two?
Answering your question I think you have...
October 14, 2008 at 2:25 am
1- Take two backups, verify after completion and have dump files in different sets of media.
2- Drop your database
3- Pre Create your database with the proper sizes.
4- Restore your database...
October 14, 2008 at 1:17 am
I would love to agree but I just can't 😀 Happens we -or at least I - are talking about a very specific case which is STG tables properly...
October 14, 2008 at 1:12 am
... and it did actually free up space... inside your affected PRIMARY filegroup 🙂
October 13, 2008 at 11:07 am
Viewing 15 posts - 2,836 through 2,850 (of 3,061 total)