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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2010 at 1:25 pm
Why are you taking differential backups every hour?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2010 at 5:07 am
Can you run a checkDB of model please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2010 at 1:55 am
Viewing 15 posts - 33,466 through 33,480 (of 49,552 total)