Viewing 15 posts - 16 through 30 (of 141 total)
Thanks, not only do I struggle with UNPIVOT.
I also cannot figure out apply. I get it when passing parameters in e.g. apply yo every value.
Is this the same as
November 18, 2020 at 6:57 pm
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
Viewing 15 posts - 16 through 30 (of 141 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy