Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,816 through 19,830 (of 59,072 total)

RE: Converting a column of type nvarchar to datetime

aldous.chris (8/19/2015)
Hi All,
Thanks for your help and quick responses. There were values which weren't allowed in the column!
All columns have been successfully updated!
Cheers,
Chris
There are very few places in...
--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)

August 19, 2015 at 9:10 pm

#1821245
RE: Update Statistics & Rebuild index (MaintenancePlan)

One of the more recognized solutions for index maintenance can be found at the following link.
https://ola.hallengren.com/
--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)

August 19, 2015 at 9:06 pm

#1821242
RE: Update Statistics & Rebuild index (MaintenancePlan)

lgluna20 (8/19/2015)
Hello
I hope you are fine.
I have a questions about Update Statistics & Rebuild index.
Every day I have a maintenance Job of my DBs where I Include Update Statistics...
--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)

August 19, 2015 at 9:04 pm

#1821241
RE: SQL Turn Row data to Column

Dee Dee-422077 (8/19/2015)
Hi,
ItemID ItemName Price
1 Test 1 100
1 ...
--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)

August 19, 2015 at 8:59 pm

#1821239
RE: SQL Turn Row data to Column

Jayanth_Kurup (8/19/2015)
http://stackoverflow.com/questions/20057655/multiple-rows-in-one-column-sql-server
Have you seen this ?
That's concatenation rather than creating separate columns for common items.
--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)

August 19, 2015 at 8:58 pm

#1821238
RE: Can't use >= with setInt

serviceaellis (8/19/2015)
Currently working with
DECLARE @yr AS int;
SET @yr = 2015;
which is used in
WHERE (YEAR(EndDate) = @yr)
...
--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)

August 19, 2015 at 8:56 pm

#1821237
RE: adventure works sample database from microsoft

If you're serious about learning SQL Server, stop farting around with the free stuff and by the Developer's Edition for about $60USD. People bitch about the price but that's...
--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)

August 19, 2015 at 8:29 pm

#1821232
RE: Looping through XML data and replace words with table values using SQL

Luis Cazares (8/19/2015)
Use the REPLACE() function.
Heh... and here I thought I was the only one that did such a thing. KISS works wonders! 😛
--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)

August 19, 2015 at 8:06 pm

#1821231
RE: Looping through XML data and replace words with table values using SQL

bhanutejan (8/19/2015)
Expecting help immediately.
Thanks in Advance
Send money for immediate help. This is a free forum, not a paid site. 😉
--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)

August 19, 2015 at 9:23 am

#1821104
RE: Where IN @txtVariable (where txtVariable is a CSV list)

Probably the best way here, taking the appropriate precautions against SQL Injection, would be a lick of dynamic SQL.
--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)

August 19, 2015 at 9:17 am

#1821099
RE: Database in use

Jacob Wilkins (8/19/2015)
I prefer to avoid all that silliness and set DBs offline with rollback immediate prior to restoring on top of them. I'm quite confident no one else 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)

August 19, 2015 at 9:14 am

#1821098
RE: Read a file from FTP directly

karthik82.vk (8/19/2015)
Hi
Thanks for the reply.
SO i need to download it from ftp and then only i have to read it right.
Correct. That's when "Excel Hell" takes over....
--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)

August 19, 2015 at 9:05 am

#1821094
RE: Changing roles

Revenant (8/18/2015)
Jeff Moden (8/18/2015)
Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that 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)

August 19, 2015 at 7:25 am

#1821039
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/18/2015)
Well I fly to Louisville Thur, so I'm just hoping my updateFlightSystemaphobia is just a phobia this week.
Take a computer with bad software on it...
--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)

August 18, 2015 at 5:01 pm

#1820917
RE: SQL server login succeed many times in log

Lowell (8/18/2015)
also, think about any items you might have installed, whether running in the background or as a service, that are running under your credentials, maybe something like RedGate lighthouse...
--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)

August 18, 2015 at 9:54 am

#1820804

Viewing 15 posts - 19,816 through 19,830 (of 59,072 total)