While it is maybe not technically a system database, things skipping system databases should probably also exclude [distribution]. In recent versions of SSMS (SQL Server Management Studio), Object Explorer groups...

While it is maybe not technically a system database, things skipping system databases should probably also exclude [distribution]. In recent versions of SSMS (SQL Server Management Studio), Object Explorer groups...

Dang! I just implemented some bitmapped stuff in SQL Server 2019, and I had to write similar functions myself. It will be a while before the non-profit I work for...

• This reply was modified 6 months, 2 weeks ago by JediSQL. Reason: missed a couple words

Hi,

On my server, srvid from master.dbo.sysservers is definitely NOT the source for distribution.dbo.MSsubscriber_info.subscriber_id.

I found this discussion because I was looking for a way to get the default value for an int column. Here is what I came up with:

declare
...

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...

• This reply was modified 3 years, 10 months ago by JediSQL. Reason: punctuation

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 store balances...

Well, that's disappointing.

• This reply was modified 4 years, 1 month ago by JediSQL.

Testing and Results

I used the UDF from the  script I contributed .

Please fix link to  script  so I can compare my gaps query.

• This reply was modified 4 years, 4 months ago by JediSQL.

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...

That's what I was wondering about. When SQL Server is running...

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...

• This reply was modified 4 years, 6 months ago by JediSQL. Reason: fix formatting of bullet points

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()...

• This reply was modified 4 years, 8 months ago by JediSQL.

Hi. Here are a few points from me...

1. The overall success of a job depends on the success status of the last step run, even if an intermediate step failed...

Hi,

I posted a request to fix this at Microsoft's User  Voice forum:

https://feedback.azure.com/forums/908035-sql-server/suggestions/41700883