Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,326 through 17,340 (of 59,067 total)

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
RE: Concatenate strings

ScottPletcher (7/1/2016)
So if a column changes from non-unicode to unicode, you're going to insist that all existing code be changed to explicitly specify unicode strings for that column?
Actually, yes. ...
--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:29 pm

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

Since this is 2016, seems like a Lead or Lag would be the way to do this.
--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 3:47 pm

#1888172
RE: Concatenate strings

ScottPletcher (7/1/2016)
I still say don't explicitly code it unless the code requires it (some system procs require unicode strings specifically, for example), because it can cause performance errors or...
--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 10:50 am

#1888127
RE: Concatenate strings

Agreed... and the catch here is that if this happens, what else could happen? If you use the "N" prefix for the literals whenever NVARCHAR is used, it's pretty...
--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 9:27 am

#1888119
RE: Concatenate strings

Sergiy (6/30/2016)
ScottPletcher (6/30/2016)
Jeff Moden (6/24/2016)
Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals. ...
--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 7:36 am

#1888089

Viewing 15 posts - 17,326 through 17,340 (of 59,067 total)