Viewing 15 posts - 33,466 through 33,480 (of 49,552 total)
jpSQLDude (3/16/2010)
Lynn Pettis (3/16/2010)
If the full backup taken at 1:00 PM is the first ever full backup, your t-log backup at 1:05 PM would fail
If you mean Fail as in...
March 16, 2010 at 1:29 pm
That should parameterise fine, which means possibly a different version of parameter sniffing.
Can you get an execution plan of that please? You can capture that with Profiler, it's the ShowPlan...
March 16, 2010 at 1:25 pm
Why are you taking differential backups every hour?
March 16, 2010 at 1:14 pm
That'll work, as long as they're asking for one subject only. If the question was for the student with the highest park per subject, then just doing a TOP (LIMIT)...
March 16, 2010 at 7:45 am
Hang on a minute.....
LIMIT and CONCAT are mySQL, not SQL Server. Looking at your table creation scripts, they're MySQL as well.
MySQL and MS SQL Server are two very different products,...
March 16, 2010 at 5:51 am
Ok, so what is it that you want? As I indicated earlier, I'm not going to give you the answers. I'm not the one doing the course, I don't need...
March 16, 2010 at 5:31 am
Please post table definitions, 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/
However....
We don't answer homework questions here. We'll give...
March 16, 2010 at 5:07 am
Can you run a checkDB of model please?
March 16, 2010 at 5:06 am
Paul White (3/16/2010)
GilaMonster (3/16/2010)
I feel another blog rant coming.See if you can include that http://en.wikipedia.org/wiki/Argument_from_authority link. Very cool.
I think that's a different rant. The thread I think you're referring...
March 16, 2010 at 4:58 am
Ratheesh.K.Nair (3/15/2010)
So u mean that they need to keep the compatability level in 80 for a sql server 2008 server?
No, but changing the compat mode is not going to fix...
March 16, 2010 at 3:58 am
There's no 'undelete' if that's what you're asking.
If you know the definition of the consraint, you can recreate it with ALTER TABLE. If not, restore the backup somewhere else, get...
March 16, 2010 at 3:56 am
It's in sys.partitions.
From BoL
data_compression int
Indicates the state of compression for each partition:
0 = NONE
1 = ROW
2 = PAGE
sys.partitions has both object_id and index_id, so you can join...
March 16, 2010 at 3:52 am
Paul White (3/16/2010)
I am quite happy to educate him on the subject, it just frustrates me when people post authoritative-sounding statements that are just plain wrong...!
I feel another blog rant...
March 16, 2010 at 3:45 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic883581-391-1.aspx
March 16, 2010 at 2:12 am
If you're rebuilding all your indexes, you're modifying just about the entire database, hence any differential run after that, before the next full backup will be large, because they contain...
March 16, 2010 at 1:55 am
Viewing 15 posts - 33,466 through 33,480 (of 49,552 total)