Viewing 15 posts - 14,731 through 14,745 (of 49,552 total)
My guess is full recovery model and no log backups
Please read through this - Managing Transaction Logs[/url]
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
January 19, 2013 at 9:53 am
As I mentioned previously (http://www.sqlservercentral.com/Forums/Topic1407762-391-1.aspx)
You'd have to restore the primary filegroup backup, the the secondary, then all the log backups since the oldest of those 2 backups to bring the...
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
January 19, 2013 at 9:52 am
An index rebuild updates the stats associated with that index as part of the rebuild operation
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
January 19, 2013 at 2:39 am
Because the second query becomes essentially
select a,b,c from MyTable
where CAST(a AS nvarchar(2)) in(N'Ab',N'BC',N'CD')
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
January 18, 2013 at 3:09 pm
Revenant (1/18/2013)
Brandie Tarvin (1/18/2013)
Chad Crawford (1/18/2013)
wolfkillj (1/18/2013)
Evil Kraig F (1/17/2013)
Was ill for a week, miss anything of import?
MS announced that SQL Server 2012R2 will be released in late 2014...
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
January 18, 2013 at 12:33 pm
If you want an explanation, I need to see the plan, not a partially blacked out image of the plan.
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
January 18, 2013 at 12:32 pm
bwperrin (1/18/2013)
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
January 18, 2013 at 7:21 am
jerome.morris (1/18/2013)
s varchar(50) will always use 50 spaces or however you call them.
No it doesn't.
Char(50) always uses 50 bytes, varchar(50) uses as much space as the data in it (plus...
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
January 18, 2013 at 6:12 am
PTPortal.PTPortalUser.PTJOBLOGS has a corruption in its clustered index. Take the DB into single user mode and run DBCC CheckDB(PTPortal, repair_rebuild)
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
January 18, 2013 at 4:00 am
prakash.kumar3669 (1/17/2013)
GilaMonster (1/17/2013)
Index on (IsDeleted, SubmitDate DESC) include (ProdName,Category,TotalStock,Price)What would be the exact sql query to create the index.
Why don't you open up books online and read over Create Index.
btw,...
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
January 18, 2013 at 3:00 am
jitendra.padhiyar (1/18/2013)
Yesterday I tried to run checkdb with repair_rebuild option but fails due to log file full. I will try again after shrinking db log file.
Shrinking a full log is...
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
January 18, 2013 at 2:56 am
http://sqlinthewild.co.za/index.php/2009/09/22/estimated-rows-actual-rows-and-execution-count/
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
January 17, 2013 at 4:00 pm
Wait analysis
Performance benchmarking
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
January 17, 2013 at 9:44 am
Maybe. Maybe not.
Try it out in a test environment and see. Also, check why the operations are taking so long, what the wait type is that they get.
http://www.sqlservercentral.com/articles/Indexing/68563/
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
January 17, 2013 at 9:35 am
Dave62 (1/17/2013)
Does this apply only to executing sql from an application then?
No.
If I have a stored procedure that accepts parameters and build an sql string within the stored procedure, does...
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
January 17, 2013 at 8:17 am
Viewing 15 posts - 14,731 through 14,745 (of 49,552 total)