If you want today before 23:00, then it would be

datecolumn < dateadd(HOUR, 23, convert(datetime2(0), convert(date, sysdatetime())))

But you are talking about five o'clock in the morning, so maybe you really mean...

In the same module, there can only be one CREATE TABLE/SELECT INTO for the same table. That is just the way it is. It is a holdover from SQL 6.5,...

If you are assuming that we know the tables you are working with, I will have to disappoint you. We don't.

The normal recommendation when people ask with help to form...

It's not fully clear to me what result you are looking for. Can you post CREATE TABLE + INSERT statements with some sample data and what result you want?

I can...

Don't use the Table Designer to change tables. It is utterly buggy and outright dangerous. It may decide to create a new table and copy data over when there is...

And the error is?

Because at the time the trigger is compiled, ARITHABORT is still ON. The SET command is not a declaration, but an executable statement.

Here is a demo. The database has to...

Requires compat mode 80? Only supported up to SQL 2008, which is itself is out of support. Time to look for a replacement, I'm afraid!

As for the actual problem, it...

IF OBJECT_ID('tempdb..#data') IS NOT NULL DROP TABLE #data
IF OBJECT_ID('tempdb..#pivotcols') IS NOT NULL DROP TABLE #pivotcols
CREATE TABLE #Data (AccountId int, YrMo varchar(6), Amount int)
INSERT INTO #data
SELECT 10001, 201906,...

That stopped with SQL 2005. More precisely, SQL 2008 was the first version where BUILTIN\ADMINISTRATORS were not added by default.

so it wont take hours to roll back.

There is no much rollback with shrink. It works with many small transactions as it moves pages around.

Note that to move the tables...

Are there LOB columns in the database? If there are LOB columns it takes forever to shrink the database. Or more precisely: it can take a very long time. And...

To be able to use ALTER TABLE PARTITION SWITCH, all indexes on the table must be on the partition scheme.

So change

CONSTRAINT UQNP_MyTable_IndexGUID UNIQUE NONCLUSTERED ON [PRIMARY],

to

            
September 13, 2019 at 8:53 pm
            
#3679984

            
            
                                                
        

I don't know in which order connections and sessions are created, and I don't think it is relevant. I would say that for all practical purposes, they appear at the...

See session as the main concept. It is identified by the session_id, and it exists as long as the user is logged in. There are also sessions which are internal...