Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,821 through 20,835 (of 59,072 total)

RE: Adding RowID to existing table = Wildly Inconsistent Results!

It would work as expected if you did your BULK INSERT into a table that already has an IDENTITY column. You would need to either put a view on...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 7:57 pm

#1796449
RE: Table Without PK

Ed Wagner (5/7/2015)
Another difference is when you create nonclustered indexes on the heap, each row can't inherit the bytes of the primary key. Instead, it inherits the bytes of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 7:40 pm

#1796447
RE: Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

marcia.j.wilson (5/7/2015)
Jeff Moden (5/7/2015)
... I would have expected an article on "Advanced T-SQL" to better explain what cursors should be used for, why they should generally be avoided,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 7:26 pm

#1796445
RE: Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Oddly enough, Jim, those are SET based operations being controlled by a loop or "cursor"... just smaller sets. It's a tried and true method for doing (for example) massive...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 6:54 pm

#1796443
RE: Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

You don't need cursor processing for what you're talking about Jim.
You do bring up a point though. I would have expected an article on "Advanced T-SQL" to better explain...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 5:02 pm

#1796436
RE: script to create role

charipg (5/7/2015)
Actually I am struggling for a complete script
Need a script to create a new role in all databases to cover SP creation/execution, any table data manipulation (insert,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 4:18 pm

#1796430
RE: Are the posted questions getting worse?

GilaMonster (5/7/2015)
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.
Article requests?
How about: Partitioning for performance, what it really means. 😛
This one not good enough? https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Hey,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 4:15 pm

#1796429
RE: Archieving Data

Lynn Pettis (5/7/2015)
Jeff Moden (5/6/2015)
Lynn Pettis (5/6/2015)
ramana3327 (5/6/2015)
We are using Sql 20082 Standard edition. Data drive has enough free space but that table stores the errors that we don't required...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2015 at 11:08 am

#1796316
RE: Indexes Fragment Really Quickly

I figured as much. Vendors aren't so helpful.
Can we narrow down the type of performance problem that you're experiencing? For example, are the performance issues on SELECTs, INSERTs,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 8:23 pm

#1796101
RE: Archieving Data

ramana3327 (5/6/2015)
Space means in the destination server or source server?
Here is the table structure
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ERRORS](
[Id] [uniqueidentifier] NOT NULL,
[InnerErrorId] [uniqueidentifier] NULL,
[CreatorFK] [uniqueidentifier] NOT NULL,
[Created] [datetime] NOT...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 8:05 pm

#1796100
RE: execute xp_cmdshell - cant get it to work - no matter what - any one?

Lynn Hendricks (5/6/2015)
Well your suggestions worked.
After I was going to post the DDL, I noticed an error in the SQL statement.
And as I fixed that, the xp_cmdshell to create the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 8:03 pm

#1796099
RE: Archieving Data

Lynn Pettis (5/6/2015)
ramana3327 (5/6/2015)
We are using Sql 20082 Standard edition. Data drive has enough free space but that table stores the errors that we don't required to store more than...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 6:06 pm

#1796089
RE: How can I audit how many times a Trigger in sql2005 fires

SlapShot John (5/6/2015)
Yes I agree completely and we are doing just that but a lot of finger pointing and this was tasked to us to see if we could do...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 11:01 am

#1796024
RE: How can I audit how many times a Trigger in sql2005 fires

john.yori 32529 (5/6/2015)
Hi we have a legacy application running on sql2005. We suspect part of our performance issues is from the table triggers being fired so Development wants me...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 10:26 am

#1796011
RE: execute xp_cmdshell - cant get it to work - no matter what - any one?

At this point, I'd recommend posting the DDL for the stored procedure.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2015 at 9:48 am

#1795991

Viewing 15 posts - 20,821 through 20,835 (of 59,072 total)