Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @Users table(UserID int identity(1,1) primary key,Name varchar(50),Active bit);

declare @CreditCards table(IdCredicard int identity(1,1) primary key, UserID int,CardNo bigint,Active bit,Date_Created datetime);

insert into @Users(Name,Active)

select 'Name1',1 union all

select 'Name2',1...

peter 82125 (8/10/2015)

---

When I first opened Books Online, I chose the option to run the documentation online rather than locally; now I would like to change that to locally. Can...

Further on the subject, what is killing the performance is most certainly the distinct sort and table scans for the xml subquery. Adding an index on InvoiceID, Row_Num and include...

Quick thought, too much information missing, without it one is just guessing!

😎

Post the...

jan.dewettinck (8/9/2015)

---

Thanks for the question

Not sure if the following link provides a better explanation.

https://msdn.microsoft.com/en-us/library/ms187928.aspx

I based my answer on the part about the style which says that the default is...

You are very welcome

😎

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.test') IS NOT NULL DROP TABLE dbo.test;

GO

CREATE TABLE dbo.test (

action_id numeric,

action VARCHAR(20) NOT NULL,

action_by VARCHAR(20) NOT NULL,

action_date VARCHAR(20) NOT NULL

);

INSERT INTO dbo.test (action_id,action, action_by,action_date)

VALUES...

chandrika5 (8/7/2015)

---

Just replicated it!.

I am using SQLSERVER Management Studio for both the queries.

1. select * from dbo.mytable

VS

Expand the Instance --> Databases --> tables --> Right click the table and select...

Edit: removed post.

🙂 Smiley

StillaLearner (8/8/2015)

---

Hi - I'm looking for a quick script that someone has already written to update statistics (not to rebuild or re-organise) on specific indices in specific databases - I...

As Jason said, 11.2.xxx is a typo.

😎

BTW, you should be running 11.00.5623, kb 3072100, Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 2.

Quick question, could there be more than one row returned? You can check this by filtering the set by the given parameters/predicates.

😎

Further, can you post the actual code you are...

studySQL (8/7/2015)

---

I have a data flow that brings the data from flat file (.txt) to a table but after processing few rows, it fails with this error.

Violation of PRIMARY...

Add an identity column, and as it looks the table is a heap so use the opportunity and make it clustered.