If the column DBSize is consistent then this may work

declare @SomeTable table
(
    DatabaseName nvarchar(1000) not null,
    DBSize nvarchar(1000) not null
);

insert into...

Try normalize the Employee table, to move out rows that may me NULL. Good normalization also gives more understanding of the model. Sometimes NULL, may be acceptable, e.x. a "start...

Thanks, cross apply, makes it simpler, and easy to extend.

Edit: Missed ca.Area. IIF seems nice, need to try.

Thanks 🙂

• This reply was modified 4 years, 8 months ago by  jonas.gunnarsson 52434.
• This reply was modified 4 years, 8 months ago by  jonas.gunnarsson 52434.

Have previous version of SSMS had support for in memory tables in diagrams?

The diagram in SSMS is neat, but somewhat limited, but very useful.

Only find this for 18.3.1 - Database...

You may also consider to use not null on columns, and add a primary key and may be unique index, to prevent duplicates, in the first place.

Memory leakage in some of your SQLCLR code? Usage of unsafe/old assembles, check logs?

Is there possible to upgrade reCAPTCHA  to version v3? I guess the WordPress is last version. Do the forum use a spam mod?

If low score maybe no post for...

You don't need the replace, better to use double quotes, like:

SET @SuccessQry =
'CREATE PROCEDURE #Success 
@ProcessStep VARCHAR(50)
AS 
SET NOCOUNT ON;
INSERT INTO #DataLog
(ProcessStep, StatusDesc)
VALUES 
(@ProcessStep, ''Success'')';

SET @FailureQry =
'CREATE...

• Is the errors from database procedures/functions or from outside the database?
• Do you use a stored procedure to save the error?
• Do you not need a timestamp of the...

Nice article! Several image links is broken. In all samples display the schema(i.e object_schema_name(ob.object_id) + '.' + ob.name as User_Table), and describe the importance to always use schema name in...

Back to the original question, that takes to long time.(many seconds to long time)

Hi,

I need to show a number of records per day in the dashboard of the web...

Interesting, sins of version of 2008 the COUNT(*) vs COUNT(1) should generate the same execution plan.(column 1 should be pk/not null). Also count won't read any data from the column(s),...

As in most development the code should speak for it self, and you should use:

• Source control (containing change documentation)
• Formatting tool/formatting rules
• Good and describing naming rules

Your procedure should...

I guess this you need to do this cleaning from time to time, I put my cleaning statements in an own procedure(support.Cleanup), and then make a job to run. May...

May be Identifying Relationship Between Columns In SQL can be of use?