Viewing 15 posts - 7,066 through 7,080 (of 59,070 total)
Rebuild the stats first. Let's talk about the indexes after that.
Believe it or not and depending on the type(s) of workloads they have, logical fragmentation may not actually matter for...
May 15, 2020 at 9:54 pm
Can you give a brief explanation of the nested date functions?
It's just the use of functions as operands (parameters) for other functions. Something like the following pseudo-code...
Function3( Function1(somevalue) ,Function2(somevalue)...
May 15, 2020 at 2:22 pm
Step one is to remove all doubt. Do the SELECT COUNT(*) thing on the table.
You also say that you inserted millions of rows into the heap. There are a lot...
May 15, 2020 at 1:55 pm
Disagreement noted.
However, there's nothing in what I stated that uses 24:00:00, nothing that would violate the constraint on the EndDate, and thee method I suggested actually does use the proper...
May 15, 2020 at 1:41 pm
jonathan.crawford wrote:Jeff, quit torturing the poor guy and just give him the linkhttp://www.sqlservercentral.com/Forums/Topic530630-8-2.aspx
Nice. Is there a unicode version?
No, but the conversion should be fairly simple.
Man... I can't believe...
May 15, 2020 at 1:10 am
Interesting. Does it correctly handle names like MacDonald, McDonald, van Halen, O'Leary, and things like "This is a Book"?
May 14, 2020 at 7:29 pm
Focus on what tools can do for you instead of 12 year old reports of a tool's shortcomings.
Heh... I know what you mean. I've been saying the same thing...
May 14, 2020 at 7:16 pm
...
It's funny how people think that you don't need xp_CmdShell on managed systems like Azure.
Do they also not allow for OPENROWSET()?
You can OPENROWSET (or BULK INSERT) from CSV,...
May 14, 2020 at 7:11 pm
Does the other "Initial Caps" function that you're talking about only hit the first letter of the entire string or is it more like "Title Caps"?
And this is what I...
May 14, 2020 at 7:08 pm
p.s. You might want to also look into "Temporal Tables", which are a combination of Type 2 + Type 4 SCDs that do most of the work for you. All...
May 14, 2020 at 6:20 pm
You don't actually need to store all rows that don't change to be able to do PIT (Point-in-Time) reporting. IMHO, it's actually foolish to do so because not only will...
May 14, 2020 at 6:02 pm
Thanks for your feedback. Much appreciated.
May 14, 2020 at 2:54 pm
To answer the question, I like the first one better because the first CTE DRYs out some of the formulas. It doesn't make much difference here but, when you have...
May 14, 2020 at 2:43 pm
Try this
SELECT v.n2.value('(@*:ObjectName)[1]','varchar(30)') AS Name,
p.n1.value('(@*:ObjectName)[1]','varchar(30)') AS Scope
FROM #SSISTest st
CROSS APPLY st.PackageXML.nodes('//*:Executable') AS p(n1)
CROSS APPLY p.n1.nodes('*:Variables/*:Variable') as v(n2);
Man... I remember you helping me with...
May 14, 2020 at 2:12 pm
Viewing 15 posts - 7,066 through 7,080 (of 59,070 total)