Viewing 15 posts - 16 through 30 (of 140 total)
Thanks Jeff and Sergiy for all your help.
I have a much better understanding now and have some design ideas: instead of triggers, partitioned views I can use not just in...
September 9, 2020 at 5:56 pm
I don't see much advantage to changing ProcessName or Type to a key from a "process table" or "type" table. In the face of the other tables, it's a...
September 9, 2020 at 9:44 am
Sergiy and Jeff both good points
CREATE TABLE [dbo].[LogFiles](
[ProcessName] [nvarchar](64) NOT NULL,
[type] [nvarchar](64) NOT NULL,
[From] [nvarchar](260) NOT NULL,
[To] [nvarchar](260) NOT NULL,
[Error] [int] NOT NULL,
[Message] [nvarchar](520) NOT NULL,
[DateAdded] [datetime]...
September 8, 2020 at 4:23 pm
But.. If some reports don't filter on Date they wouldn't benefit from the new index design.
The only query that actually does a select on this is the purge routine...
September 7, 2020 at 9:17 pm
Hi Sergiy
Thanks for your reply. I do appreciate it as I learn.
Happy because:
On an ANOTHER project where I was in full control i.e. loading data and reporting. I adopted...
September 4, 2020 at 12:42 pm
You're right about Type but can't change it, would require code change.
Why is an Autoincremental bigint ID a bad idea for a clustered index?
If I were to make DateAdded a...
September 4, 2020 at 8:38 am
Thanks Both
I'm pretty certain that the front-end, will make the SQL up as a string (I know SQL INJECTION!) and using a DB lib (not sure which code lib) execute...
September 3, 2020 at 9:46 pm
Thanks Jeff that's a good point, which I do not know the answer. I don't have control over the code. I doubt the support Guy I'm talking to, would know.
From...
September 3, 2020 at 4:00 pm
Thanks Brian
The view is working now!! regardless of where its being used from. Sorry if I wasted your time
I never run queries from systemdbs, this was just laziness on my...
July 9, 2020 at 5:45 pm
Pls ignore if I've misunderstood (the grid output doesn't seem to match the query)
Would adding
CAST(DATA as Date)
into your group by clause solve it. Assuming DATA is datetime...
September 19, 2019 at 9:10 am
Hi Ken - you're right - couldn't agree more.
I've contacted the vendor, I would never do this without checking first.
In this case It was more for my understanding, I've found...
September 19, 2019 at 9:04 am
No problem Phil - thank you for looking at my post
I jumped the gun somewhat, had chat with colleague. It stores next available CustID on the Application server in a...
September 13, 2019 at 6:47 pm
Hi Phil
It’s a 3rd Party DB/App, I cannot change the tables.
September 13, 2019 at 7:28 am
Could you use an Indexed view to maintain the balance?
September 12, 2019 at 11:29 pm
Grant good question so far testing has been on Server with DBs all in SIMPLE recovery mode. It does have the option for Point in time recovery, but I'd have...
November 27, 2018 at 1:57 pm
Viewing 15 posts - 16 through 30 (of 140 total)