Viewing 15 posts - 1 through 15 (of 62 total)
This is in response to Jim's aversion to cursors. As a lead DBA, I advised my team to avoid cursors unless necessary. There are times where set based processing is...
Sincerely,
Daniel
October 16, 2021 at 5:59 pm
Reading between the lines, given the 18 decimal points, I'm assuming that you are storing Ether (or some other cryptocurrency). Based on @william Rayer's explanation, maybe you should...
Sincerely,
Daniel
July 29, 2021 at 2:13 am
July 28, 2021 at 6:18 am
Testing and Results
I used the UDF from the script I contributed .
Please fix link to script so I can compare my gaps query.
Sincerely,
Daniel
April 17, 2021 at 1:02 am
We always use template SQL scripts to create tables, and for temporal tables, the HISTORY_TABLE clause is there.
CREATE TABLE dbo.TheTableName
...
( SYSTEM_VERSIONING = ON ( HISTORY_TABLE = dbo.TheTableName_hst...
Sincerely,
Daniel
March 30, 2021 at 12:50 am
These days with large SANs and LUNs, you might not do as much of that as in the past.
That's what I was wondering about. When SQL Server is running...
Sincerely,
Daniel
February 19, 2021 at 6:23 am
I work to have scripts be idempotent where feasible. However, it is not always feasible. So.... what do we call those scripts that are not idempotent? That is, what is...
Sincerely,
Daniel
February 18, 2021 at 9:58 pm
It looks like something weird happened when copying and pasting the "SQL script to initiate a backup of a database."
SELECT @MyFileName='C:\PS\SQLScript\Backup\' + REPLACE(cast(cast(convert(nvarchar(20) as nvarchar(max)) as nvarchar(max)),cast(cast(GetDate()...
Sincerely,
Daniel
December 22, 2020 at 6:32 pm
Hi. Here are a few points from me...
Sincerely,
Daniel
December 21, 2020 at 5:23 pm
Hi,
I posted a request to fix this at Microsoft's User Voice forum:
https://feedback.azure.com/forums/908035-sql-server/suggestions/41700883
Sincerely,
Daniel
October 21, 2020 at 8:23 pm
Oh, yeah, I'm in another thread on this:
Not able to create tasklist in Sql Server Management Studio
Sincerely,
Daniel
August 20, 2020 at 1:43 am
Sincerely,
Daniel
August 20, 2020 at 1:39 am
Thanks,
I did a little research on the Task List, and it seems like it is something that has been broken since SSMS 2017: Task List seems incomplete.
My coding often...
Sincerely,
Daniel
August 19, 2020 at 5:37 am
The link above to vote is dead now that MS discontinued Connect and moved to UserVoice. Here is the the updated link to the topic:
Task List seems incomplete
https://feedback.azure.com/forums/908035-sql-server/suggestions/32899060-task-list-seems-incomplete
Sincerely,
Daniel
August 19, 2020 at 5:34 am
You can complain to Microsoft here:
Sincerely,
Daniel
July 17, 2020 at 5:54 pm
Viewing 15 posts - 1 through 15 (of 62 total)