That is the transaction isolation level, configurable ie. within the connection parameters. Simplest...

Raghavendra Mudugal (5/7/2014)

---

QUOTE

Once you create a memory-optimized filegroup, you can only remove it by dropping the database. In a production environment, it is unlikely that you will need to remove...

That would be implicit rounding:cool:

More like this

'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round((Total_Amount/12),2) as MONEY),1), '.00', '') as Monthly_Amount,

😎

Just move the division inside the round function.

😎

martin.whitton (5/7/2014)

---

Is a "tiny bit" a "bit" that will only store zeroes? 😀

My personal feeling is that "bit" is not...

Ove.Kernell (5/7/2014)

---

Hi all,

If I have a table

CREATE TABLE [dbo].[logg](

[Id] [bigint] IDENTITY(1,1) NOT NULL,

[Details] [varchar](MAX) NULL)

insert logg (Details) values('')

insert logg (Details) values(null)

Will both statements above access only a single page (as...

Is this...

You can use a delete trigger, output the deleted into a table. Easy to use any of the security functions (CURRENT_USER, ORIGINAL_LOGIN(), SESSION_USER, USER, USER_NAME(), SYSTEM_USER) as a column default...

You are missing the increment of the counter, the code never hits it, improved code below

😎

--Set Variables for randomizing Information, et al

DECLARE @localChestTier int, @ItemLimit int, @counter int,@ItemCounter int

SET @counter...

SSIS + Script Task

or

Load to a table (SSIS/bcp/openrowset) and. search in SQL

or

Powershell...

or

External application

or

batch file + sqlcmd

or

....

😎

Quick question, is the recovery model the same and is there any difference in the connections, ie. isolation?

😎

This is a modification to Chris's code, just set the values for start id and record number and off it...

Start by checking out this article Context Is Everything - Check Your Settings[/url]

😎

Would it be an option to use raw files[/url] for the lookup?

😎