Viewing 15 posts - 571 through 585 (of 2,458 total)
If you're a good DBA, Developer or Architect it's time to go when you don't love what you're doing. The market is too starved for talent to be at a...
-- Itzik Ben-Gan 2001
July 25, 2016 at 8:34 pm
amanspschauhan (7/25/2016)
I have two Tables as shown below-
Details-
Company Name CEO ID Manager ID
A ...
-- Itzik Ben-Gan 2001
July 25, 2016 at 2:20 pm
not all reports will use the same date parameters, fortunately all of the reports have same parameter names.
First, can you clarify what you mean here?
•Would all the 9 reports...
-- Itzik Ben-Gan 2001
July 25, 2016 at 2:13 pm
mike 57299 (7/25/2016)
Unfortunately, your suggestion is greek to me. Can you explain a bit more? And yes, it is killing performance.Thank you.
I was going to suggest that you create...
-- Itzik Ben-Gan 2001
July 25, 2016 at 1:12 pm
Luis Cazares (7/25/2016)
-- Itzik Ben-Gan 2001
July 25, 2016 at 12:55 pm
Scalar functions for computed columns or constraints will hurt performance too. For one, queries that reference the table that uses a scalar udf for the computed column will likely be...
-- Itzik Ben-Gan 2001
July 25, 2016 at 11:37 am
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,
-- Itzik Ben-Gan 2001
July 25, 2016 at 9:15 am
Great work David. Very interesting, I was not aware that you could do this with Extended Events.
-- Itzik Ben-Gan 2001
July 25, 2016 at 6:29 am
If we're busting out splitters then another way would be using PatternSplitCM[/url].
DECLARE @SomeTable TABLE (SomeString varchar(100));
INSERT @SomeTable VALUES ('Recalc 2015659341589653'),('Recalc of 2015658926358915 revised'),
('Recalc to clm 15649687415315781536 error');
SELECT SomeString, Item
FROM...
-- Itzik Ben-Gan 2001
July 20, 2016 at 11:10 am
no prob. 😛
Read up on tally tables if you don't know about them. They're an invaluable tool.
-- Itzik Ben-Gan 2001
July 20, 2016 at 9:54 am
One approach using the DelimitedSplit8K_LEAD[/url]:
DECLARE @searchstring varchar(100) = '2,5';
SELECT searchstring = @searchstring, [count] = COUNT(*)
FROM
(
SELECT c.ComponentInfoID, mx, [count] = COUNT(*)/mx
FROM ComponentInfoID c
CROSS APPLY dbo.DelimitedSplit8K_LEAD(c.ComponentInfoID,',')...
-- Itzik Ben-Gan 2001
July 20, 2016 at 9:52 am
This is a job for a tally table[/url]!
Here's a crash course on how they work. Run this:
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))-1 FROM
(VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) a(x), -- 10
(VALUES...
-- Itzik Ben-Gan 2001
July 20, 2016 at 8:40 am
Another couple options:
1. You can use DigitsOnlyEE[/url]. This exactly the type of task it was designed for (note my comments):
-- How to use dbo.DigitsOnlyEE
SELECT DigitsOnly FROM dbo.DigitsOnlyEE('Recalc 2015659341589653');
SELECT DigitsOnly FROM...
-- Itzik Ben-Gan 2001
July 20, 2016 at 7:51 am
ALTER TABLE employees
ADD CONSTRAINT check_length
CHECK (LEN(fieldname) < 1)
Should be
ALTER TABLE employees
ADD CONSTRAINT check_length
CHECK (LEN(fieldname) = 1)
But this could be handled by using a nullable char(1) data type:
ALTER TABLE employees
ALTER...
-- Itzik Ben-Gan 2001
July 20, 2016 at 7:17 am
PB _BI touched on this...
I'm assuming you're attempting to use that expression in a text box properties/color setting... you can put a color or expression in there. if it...
-- Itzik Ben-Gan 2001
July 20, 2016 at 6:12 am
Viewing 15 posts - 571 through 585 (of 2,458 total)