Viewing 15 posts - 5,341 through 5,355 (of 13,873 total)
July 28, 2017 at 2:03 pm
July 28, 2017 at 1:45 pm
The DTA is not kindly looked upon in these forums. It tends to produce quirky recommendations.
There are far better ways of tuning indexes, if you are interested...
July 28, 2017 at 1:43 pm
I have cubes where their folders are built from facts and dimension tables, and in...
July 28, 2017 at 8:13 am
If you run the same query from, say, Access, (using the same driver) is there still an attempt to create the VIEWs?
July 28, 2017 at 6:03 am
We’ve got a weird thing happening and I wanted to run it past you...
July 27, 2017 at 2:31 pm
July 27, 2017 at 9:30 am
July 27, 2017 at 6:43 am
ThomasRushton - Thursday, July 27, 2017 5:17 AMUpdate the metadata in the binaries...? My head hurts.
..from laughing so much.
July 27, 2017 at 6:39 am
Presumably you can write the query to get 'date last invoice loaded'.
Here is a query to get 'last billing date':SELECT
LastBillingDate = IIF(DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 24)...
July 26, 2017 at 1:47 pm
OK, but what is your question?
July 26, 2017 at 12:52 pm
July 26, 2017 at 9:20 am
July 26, 2017 at 8:30 am
July 26, 2017 at 7:46 am
Does your source table have a primary key?
Does it have DateCreated and DateModified columns?
July 26, 2017 at 7:30 am
Viewing 15 posts - 5,341 through 5,355 (of 13,873 total)