Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,356 through 17,370 (of 59,102 total)

RE: Rename file - prefix with file date

jeffe_verde (7/4/2016)
Thank you both for the excellent suggestions. I ended up configuring a ForEach Loop container to enumerate by file date, as described in this article.
For those that...
--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)

July 4, 2016 at 11:46 am

#1888350
RE: Rename file - prefix with file date

Phil Parkin (6/28/2016)
Jeff Moden (6/27/2016)
jeffe_verde (6/26/2016)
The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names), and each...
--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)

July 4, 2016 at 11:43 am

#1888349
RE: Improvements in SQL Server Environment

rkrpat (6/29/2016)
Hi All,
This is general question and not any Technical one.
Our SQL Server environment is stable and we are being chased for Service Improvements.
Could you please suggest any improvements that...
--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)

July 3, 2016 at 11:05 pm

#1888244
RE: Global change with powershell for sql

mario17 (6/27/2016)
Hi,
I need to make global change in source code for sp for 200+ procedures, I did some python script for this, but now we decided that we need to...
--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)

July 3, 2016 at 11:02 pm

#1888243
RE: Continuous Blocking

ramana3327 (6/21/2016)
Hi Experts,
We are receiving continuous alerts about the alers. One of the insert statement is the main blockger.
I didn't get the permission to kill that spid
Do I need to...
--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)

July 3, 2016 at 10:58 pm

#1888242
RE: in dynamic sql , creating temp table in with in dynamic sql is good or it should be out side.

rajemessage 14195 (7/3/2016)
hi,
i have one dynamic sql and in need one temp table like
declare @db varchar(200)
declare @tablename varchar(200)
declare @sql varchar(max)
[font="Arial Black"]@sql='create table @temp1(a int null)[/font]
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)

July 3, 2016 at 10:46 pm

#1888241
RE: not able to find why/where this error is comming.

Have you tried searching for "The current transaction cannot be committed and cannot support operations that write to the log file".
Also, any triggers on the tables?
--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)

July 3, 2016 at 10:42 pm

#1888240
RE: Are the posted questions getting worse?

Eirikur Eiriksson (7/2/2016)
Spam, spam and again spam 🙁 Why on earth is it so hard to tackle this problem on sqlservercentral.com???
😎
From what I've heard, it's because they don't have 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)

July 3, 2016 at 10:33 pm

#1888239
RE: how to Copy .bak file from S3 to RDS - Amazon Cloud

I read that article and I can't help but think that the cloud is becoming more like smoke and mirrors. Now you see it, now you don't.;-)
--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)

July 3, 2016 at 2:46 pm

#1888228
RE: One more SQL puzzle

ammit.it2006 (7/2/2016)
I also tried something similar..............:-P
select ROW_NUMBER() over(order by id) , name From Table1
union
select ROW_NUMBER() over(order by id) +3, name From Table2
Unfortunately, that presupposes the esoteric knowledge that you...
--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)

July 2, 2016 at 11:45 am

#1888208
RE: upgrading from 2008r2 to 22014 questions

Quinn-793124 (7/1/2016)
Hi,
How do you determine of SQL Server 2008 I am on so I can get the same level at 20014 so I don't lose functionality and compatible...
--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)

July 2, 2016 at 8:39 am

#1888194
RE: Correct MAXDOP setting

smthembu (7/2/2016)
Hi All,
Thanks for your response. To answer a few
The VM is hosted with other VM's running on the same tin of which I dont have the number of other...
--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)

July 2, 2016 at 8:30 am

#1888193
RE: Correct MAXDOP setting

It won't work for every SQL Server instance out there but I tend to use MAXDOP as a bit of a poor-man's resource governor. In my eyes, no one...
--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)

July 1, 2016 at 6:13 pm

#1888181
RE: SQL 2012 to 2016 - Possible Application Issues

Br. Kenneth Igiri (6/27/2016)
In upgrading from SQL Server 2012 to 2016, based on your experience, what are possible impacts the upgrade could have on an application that was built for...
--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)

July 1, 2016 at 5:44 pm

#1888179
RE: Decreasing a value across multiple rows until 0

The Dixie Flatline (7/1/2016)
Just did some quick reading. Didn't find a LAG solution, but windowed functions are awesome for this.
In the OPs problem at hand, we need something...
--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)

July 1, 2016 at 5:33 pm

#1888178

Viewing 15 posts - 17,356 through 17,370 (of 59,102 total)