Viewing 15 posts - 4,021 through 4,035 (of 49,552 total)
Welsh Corgi (12/13/2015)
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
December 13, 2015 at 2:47 am
Gazareth (12/11/2015)
Step 1. While management are still high on whatever drugs they're taking, ask for a pay rise. 😀
This!
2, 3 and 5 (mostly, though it'll be for all tables and...
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
December 12, 2015 at 11:27 am
UDFs are slow. They run once per row. The optimiser cannot cost them properly. The problem is the UDF usage.
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
December 12, 2015 at 4:30 am
Nonclustered indexes are not rebuilt when the clustered index is 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
December 12, 2015 at 4:28 am
I'd have recommended Jonathan's book, but doing so seems to be redundant. Chapter 1 and Chapter 6 mainly (I think 6 is blocking)
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
December 11, 2015 at 12:26 pm
feersum_endjinn (12/11/2015)
It's possible they are doing a copy only backup every 24 hours to distribute via FTP while some other backup application does more frequent backups.
No.
A copy-only log backup doesn't...
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
December 11, 2015 at 7:59 am
Then you're going to need to create a calendar table that has all months in it (and just columns related to the dates) and query that table LEFT JOIN to...
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
December 11, 2015 at 7:08 am
Grant Fritchey (12/11/2015)
Yikes.Why not simply keep the database unrecovered and continue to apply log files to it every day?
Customer seems to want a read-write DB where the changes are discarded...
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
December 11, 2015 at 7:06 am
No. Why would there be?
Would you really want an index rebuild that could take hours in the middle of a delete query's execution?
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
December 11, 2015 at 6:51 am
It's the operator which does the actual delete of the rows from the table. Looks like you have a cascading foreign key, so when you delete from the parent table,...
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
December 11, 2015 at 6:43 am
Are there rows for november in your calendar table dbo.Filteredfs_carvelgmrcalendar?
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
December 11, 2015 at 6:36 am
johnwalker10 (12/10/2015)
First, I set up the database recovery model as SIMPLE
Which will not do a thing in this situation, as the log is full due to an active transaction.
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
December 11, 2015 at 2:00 am
Just based on those queries and no other:
Index ON Article (websiteid, IsActive, startdate, enddate) include (isfeatured ,istopstory ,isbreakingnews ,islatestnews)
Or, as an alternative, if the filter for IsActive is ALWAYS IsActive...
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
December 11, 2015 at 2:00 am
In a properly tuned OLTP database, it should be milliseconds. An analytics system would probably take longer-lasting locks because it's doing larger queries. It's not about normal, it's about whether...
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
December 10, 2015 at 2:23 pm
You can try that. It does mean that your invoicing will be serialised and so might run longer and be slower. If that's acceptable, give it a try.
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
December 10, 2015 at 2:15 pm
Viewing 15 posts - 4,021 through 4,035 (of 49,552 total)