Quick SQL Server 2000 solution, both limited and cumbersome but works

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE #SAMPLE_DATA

(

SD_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...

Quick cross-tab solution.

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(DOG,Name,Color,Age) AS

( SELECT * FROM (VALUES

('Boxer' ,'BO' ,'Fawn' ,1)

...

Quick thought, run both queries in the same query window with "Include Actual Execution Plan" turned on. Then compare the two plans and tell us what the difference is.

😎

Luis Cazares (10/14/2014)

---

That sounds like a good and bad news. And the good news sound great.

Thank you for the update, Steve.

In an unrelated topic, have you ever seen a code...

Further on Lynn's request, the actual execution plans?

😎

Another quick solution, less flexibility but only a single table scan

😎

USE tempdb;

GO

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

create table dbo.example

( a int null,

b varchar(100) null,

c varchar(100) null,

d varchar(1000)...

Initial request is slow, subsequent requests are fine

😎

Quick thought, use the OUTPUT clause in the stored procedure to insert into the audit table.

😎

Quick question, can you post the full DDL of the table and the indices?

😎

Quick questions, which product code? Is there only one product code or should it be any product code? What's the role of the variable, wouldn't it be better to have...

kyiaun (10/13/2014)

---

Anyone who know to advise of MSSQL 2008 Standard version With & Without Nested Loops (inner join) for Select statement which is the more performance?

Declare @id int

Declare @i int

Declare...

Then everything is pointing to the name resolution, check the DNS, win host name etc.

😎

Quick solution and an opposite problem to Jeff's, lots of coffee but yet to be drunken.

😎

USE tempdb;

GO

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

create table dbo.example

( a int null,

b...

You cannot rename an instance, only the server

😎

Quick suggestion, in SQL Server configuration Manager, Server Network Configuration, Protocols for SRVDR, Enable TCP/IP. Then in the properties window set TCP Dynamic Ports 0 or blank and all IP...