Viewing 15 posts - 7,441 through 7,455 (of 59,072 total)
Please... especially when posting a shedload of code, either learn how to post the code in a code window or attach it all as a txt file. When constructing a...
March 27, 2020 at 2:14 pm
That sounds REALLY interesting, i have never been the type of person and i didn't knew you could make these kind of changes inside the engine if not using...
March 27, 2020 at 1:55 pm
Instead of waiting for you, Joe, I found ISO/IEC 9075-1, ISO/IEC 9075-2, ISO/IEC TR 19075-2, (all 3 are part of ISO SQL standard) and revisited the ISO 8601 spec.
ISO/IEC 9075-1...
March 27, 2020 at 12:49 am
>> You know that YYYY-MM-DD is the alternate format and it doesn't work in certain languages in SQL Server. You also know that the primary ISO format is YYYYMMDD....
March 26, 2020 at 10:14 pm
Hey, Joe. Please read a good book on SQL Server, Databases, Scales, and do actually read the ANSI/ISO standards before attempting to quote them. 😉
March 26, 2020 at 9:50 pm
Lol here they just add people to new ones, and there are layers to the onion. I have no idea how many things I'm still in after 14 years,...
March 26, 2020 at 7:15 pm
What we found out was that the users were using SSRS to make spreadsheets and reformat them and change them and add to them, etc, etc. We found...
March 26, 2020 at 6:55 pm
What we found out was that the users were using SSRS to make spreadsheets and reformat them and change them and add to them, etc, etc. We found that it...
March 26, 2020 at 5:43 pm
SELECT [name], s.database_id,
COUNT(l.database_id) AS 'VLF Count',
SUM(vlf_size_mb) AS 'VLF Size (MB)',
SUM(CAST(vlf_active AS INT)) AS 'Active VLF',
SUM(vlf_active*vlf_size_mb) AS 'Active VLF Size (MB)',
COUNT(l.database_id)-SUM(CAST(vlf_active AS INT)) AS 'In-active VLF',
SUM(vlf_size_mb)-SUM(vlf_active*vlf_size_mb) AS...
March 26, 2020 at 4:34 pm
As a bit of a sidebar, I think it funny how names of things have (inappropriately, IMHO) changed over the years. If we look at the title of this thread,...
March 26, 2020 at 2:44 pm
To add to what Frederico is talking about on the Transaction Log File, the other thing to check is the number of VLFs. The log file is almost like its...
March 26, 2020 at 2:02 pm
Consider that when we run your code, it produces 68 reads (pages), which equates to 557,056 bytes of memory I/O just to handle 7 very narrow rows of data for...
March 26, 2020 at 5:48 am
>I got this to work, however, if the month is 1-9 it sets the date to '01/01/1900' because of the month not having 2 digits.<<Clean up the souce data...
March 26, 2020 at 2:16 am
yes time is not an issue as we are only counting full days, so the two time fields can be ignored, only the date start and date end are...
March 25, 2020 at 9:48 pm
Thank You All for your help.
I am able to achieve what I was looking with few changes to the script.
So share... what changes did you make?
March 25, 2020 at 8:24 pm
Viewing 15 posts - 7,441 through 7,455 (of 59,072 total)