Viewing 15 posts - 46 through 60 (of 6,831 total)
Not a part of normalization, but I'd recommend you not use spaces in object names -- it will force the use of brackets or double quotes around those names. ...
June 14, 2022 at 2:46 pm
I've had decades of experience doing data modeling, but I have no clue for your tables. You haven't described any of the data.
Normalization deals with a logical design, containing "entities"...
June 14, 2022 at 3:07 am
Agree 100%. Talk to the vendor who sold you the license or talk to MS directly. Licensing is much more complicated now than in the past, so talk to an...
June 13, 2022 at 8:00 pm
And make sure it is the log file. That is, make sure IFI is enabled so that SQL doesn't have to initialize all the data files too.
June 13, 2022 at 5:44 pm
Focus first on logical I/Os, as that's usually the culprit one way or another.
You just re-stated exactly the first line of what I wrote in an earlier post. What...
June 10, 2022 at 7:48 pm
I think something like this will do. And you can change the "INNER JOIN" to "LEFT OUTER JOIN" if you want to show all times ranges for every Q and...
June 10, 2022 at 7:43 pm
SELECT Convert(datetime, Left(dr_value, 10), 101) as Converted_Date from dr_tracking ;
June 8, 2022 at 10:07 pm
Focus first on logical I/Os, as that's usually the culprit one way or another.
If you can run the code at will, then add this statement at the start of the...
June 8, 2022 at 5:25 pm
What is the data of "yourcolumn" (the original column)?
If it's already datetime, and you just want to strip the time off, then do this instead:
DATEADD(DAY, DATEDIFF(DAY, 0, yourcolumn), 0)
June 8, 2022 at 5:19 pm
Just remember that you'll end up with a rather huge transaction log file on Step 3 and it will take 2-3 times longer if you don't achieve "Minimal Logging".
Also...
June 8, 2022 at 4:49 pm
so maybe I need to rethink how I have structured my tables. I don't have a binary win_loss in the game data which you will see. I put...
June 8, 2022 at 4:48 pm
This might give you some helpful ideas. It also contains minimum sample data to show you how data can be posted. I used a Season table to determine the Season...
June 8, 2022 at 3:23 pm
If you're willing to get rid of the PIVOT in favor of a cross-tab approach (which IMHO is preferable anyway), then try this:
SELECT
[Type],...
June 7, 2022 at 5:54 pm
Getting carried away with the semicolons, and attempting to use two WITHs for one SELECT:
:WITH cte AS (
SELECT [cntSRVLDAPLOADAVERAGE]
FROM...
June 6, 2022 at 9:31 pm
Viewing 15 posts - 46 through 60 (of 6,831 total)