prettsons (3/26/2013)

---

Simple recovery model allows restore database only up to the last full backup, while in full recovery model, you can get point in time recovery.

You can change recovery model...

Here is the testing:

set nocount on;

-- sample data

IF OBJECT_ID('tempdb..#x') IS NOT NULL

DROP TABLE #x;

CREATE TABLE #x (id int identity primary key, val nvarchar(100) NOT NULL);

GO

INSERT INTO #x

SELECT '55,85,1,4,9888,6587'...

wolfkillj (4/19/2013)

---

Lynn Pettis (4/19/2013)

---

I was doing some testing, code below:

<snipped>

Results:

Beginning execution loop

Batch execution completed 10000 times.

----- Using DelimitedSplit/CROSS APPLY -----

CPU(ms): 422 Logical Reads:...

A slight mod to Sean's code to return the single value to a variable:

CREATE PROCEDURE dbo.GetSTNValue

(

@pFromStore INT

,@pToStore INT

,@pSTN VARCHAR(10) OUTPUT

) AS

BEGIN

DECLARE @count INT = 0

,@AWBNo...

Here is another option, don't know how it will perform or scale:

create table #a (ID int,CalYear int)

insert into #a values(1,1993)

insert into #a values(1,1994)

insert into #a values(1,1995)

insert into #a values(1,2001)

insert into...

I was doing some testing, code below:

set nocount on;

-- sample data

IF OBJECT_ID('tempdb..#x') IS NOT NULL

DROP TABLE #x;

CREATE TABLE #x (id int identity primary key, val nvarchar(100) NOT NULL);

GO

INSERT INTO...

Sean Lange (4/19/2013)

---

That is certainly interesting. I still think this is way over the top worried about naming conventions. This will be difficult to maintain when you have to update...

muthyala_51 (4/19/2013)

---

Hi All,

I had an unexpected Auto failover from Principal to Mirror server.

We saw a network spike from 32MB to 1117MB during that period in the reports but the spike...

First thing you may want to do is compare the actual execution plans for the query from each run. See if there are any differences there. You may...

I am not going to blame the problem on a bug in SQL Server. I am more likely to say there is a logic/data error somewhere in the code.

My...

Just what I was going to ask.

Looking at the CREATE TYPE statement in MSDN I don't see where it allows you to name a column constraint like you can with the CREATE TABLE statement.

Your statndards my...

labri (4/17/2013)

---

Hi everyone,

can you please help me with the following? I have a nvarchar column with data like this: ', 55,85,1,4,9888,6587,'

How can I found the rows that include in...

SELECT

[StudentID] ,

...

sqlfriends (4/18/2013)

---

I have a table that has a composite primary key studentID + Schoolyear, both of the two columns are int,

But looking at the execution plan just by using...