Viewing 15 posts - 10,456 through 10,470 (of 49,566 total)
Merge is for lots of sources and a destination where the destination needs the merged set of changes from all sources and those merged changes may get pushed back out...
January 10, 2014 at 7:11 am
BWFC (1/10/2014)
There is a philosophical question, often kicked around our office, about what happens when two people who know everything have an argument.
I'm sure I've seen that on gaming forums....
January 10, 2014 at 6:55 am
Ed Wagner (1/10/2014)
January 10, 2014 at 6:03 am
Then you need to:
Figure out what cause TempDB to grow (see Grant's post)
Determine if what caused it to grow is normal or was is a once-off operation, a broken query...
January 10, 2014 at 5:59 am
Yay, a gaggle of new graduates at the office (new employees, busy with our basic training course) and one near me seems to think that higher volume makes her opinion...
January 10, 2014 at 5:41 am
Why are you trying to shrink it? Surely if the database is 95% full (there's almost no free space left), you'd be looking to grow the database (make more free...
January 10, 2014 at 4:23 am
Possible, yes. Good idea, probably not. Why re-implement your own transactional replication?
January 10, 2014 at 4:05 am
Set max server memory to a sensible value
Chapter 4 http://www.red-gate.com/community/books/accidental-dba
January 10, 2014 at 12:41 am
SELECT DATABASEPROPERTYEX .... FROM sysdatabases
January 9, 2014 at 5:51 am
Why is a hint that will sooner or later result in incorrect results 'mandatory'? Do the people you're writing that query for realise that from time to time their results...
January 9, 2014 at 4:25 am
The first is deprecated, the second is not, both can result in incorrect results, duplicate rows and missing rows, so neither is the best to use. Best is to write...
January 9, 2014 at 3:57 am
Availability, yes, you'll need to decode the status and status2 columns in sysdatabases. Should be info in Books Online. As for when the status last changed, not unless you're tracking...
January 9, 2014 at 2:43 am
karthik babu (1/8/2014)
Those DBs aren't offline.
No, but they're shut down. That's what 'is_cleanly_shutdown' means, the database is closed, not in use. Probably they have auto_close enabled.
It's not a mystery,...
January 9, 2014 at 2:00 am
You can't use variables for file names. You need to build up the command as a string and execute it - dynamic SQL.
This is not allowed
NAME= [@DBName],
FILENAME= [@Filename]
That's...
January 9, 2014 at 1:53 am
Viewing 15 posts - 10,456 through 10,470 (of 49,566 total)