Viewing 15 posts - 12,766 through 12,780 (of 49,552 total)
Could you be a little more specific as to what you're looking for?
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
June 14, 2013 at 2:32 am
That query will do part of the work. It'll pick up table scans only on tables that don't have a clustered index, i.e. heaps. For tables that do have a...
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
June 14, 2013 at 1:32 am
chewychewy (6/13/2013)
recently just for test purpose, i actually rebuild a db woth of 100 GB indexes.But only used up 16GB transaction log.
The database was in simple or bulk-logged recovery model.
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
June 13, 2013 at 11:52 pm
chewychewy (6/13/2013)
But Does it really need 150 GB of transaction log size to do the rebuild?
Probably more than 150. 200 or 250 to be safe.
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
June 13, 2013 at 11:38 pm
UncleBoris (6/13/2013)
Out of curiosity -- what does this line "WHERE st.objectid IS NULL" do?
Filters out rows in the statement text that have object IDs and database IDs, ie...
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
June 13, 2013 at 11:25 pm
Union all usually one of the most efficient ways of concatenating result sets. The alternative to LEFT functions is usually to not use the function at all.
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
June 13, 2013 at 3:11 pm
Got a shrink operation running, automatic or manual?
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
June 13, 2013 at 3:08 pm
You can do that, in any version of SQL. If you do it and then try to restore logs you'll get an LSN mismatch error and the restore will fail.
Once...
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
June 13, 2013 at 12:04 pm
Same as any other database, roll forward then roll back. With a log shipped database the roll back portion is only done when recovering the database, the roll forward 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
June 13, 2013 at 11:02 am
nm
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
June 13, 2013 at 8:27 am
Ignore the file modification dates for SQL Server database files. They're not updated every single time a change is made to the DB, that would be useless overhead.
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
June 13, 2013 at 8:12 am
It still has a different top, different where, different select list and a different order to the OP's queries.
Boris, try this, it should be a combination of your two. I...
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
June 13, 2013 at 6:36 am
Post the procedure. It probably just needs a small tweak and not any temp tables.
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
June 13, 2013 at 6:25 am
You might want to edit that query, as it has filters and sorting that was no where in either of the queries the OP posted. It's a query on those...
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
June 13, 2013 at 6:23 am
basavarajyn (6/13/2013)
Can somebody give me some...
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
June 13, 2013 at 6:22 am
Viewing 15 posts - 12,766 through 12,780 (of 49,552 total)