Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,851 through 20,865 (of 59,098 total)

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
RE: Archieving Data

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 3 months.
Understood....
--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:43 am

#1795990
RE: New Topic Script file help

minimay (5/5/2015)
nevermind i figured it out
Declare @Julycount int
Set @Julycount= (Select Count(*) From orders Where MONTH(OrderDate) = 7)
print 'The total orders for july is ' +...
--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 5, 2015 at 9:41 pm

#1795816
RE: Archieving Data

ramana3327 (5/5/2015)
Hi,
We have one large table with 6880875 records. It has created date. The min created date is a year ago but really we doesn't required to keep the data...
--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 5, 2015 at 9:34 pm

#1795813
RE: Some Random SQL Server Best Practices

From the blog:[hr]
Joins: When coding outer joins, always order your data sources so that you can write left outer joins. Don’t use right outer joins, and never mix left...
--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 5, 2015 at 9:17 pm

#1795809

Viewing 15 posts - 20,851 through 20,865 (of 59,098 total)