Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 59,072 total)

Reply To: Having trouble with a BCP statement

itmasterw 60042 wrote:
Okay, I felt this would be more efficient and extensible ti done in SQL server, and I guess I thought it would be easier, but thanks I will 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)

October 26, 2020 at 1:56 pm

#3801311
Reply To: How to get these description from XML into the table?
DesNorton wrote:
You can take this further and split the rows into columns like this
```
DECLARE @XMLData xml;

SET @XMLData = '<PlaceDescriptions>
<descriptions>0|Home</descriptions>
<descriptions>1|Office|False</descriptions>
<descriptions>2|Play Ground</descriptions>
<descriptions>3|School|True</descriptions>
<descriptions>4|Movie Hall</descriptions>
</PlaceDescriptions>';

WITH cteXML AS (
  SELECT ...
```
--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)
October 26, 2020 at 2:38 am

#3801113
Reply To: How to reduce physical size of database

Jeffrey Williams wrote:
Cebisa wrote:
You deleted,/truncated a large amount of data, your database physical size does not autoshrink. Many suggest pre growing your data files. If you are certain that your database...
--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)

October 26, 2020 at 2:24 am

#3801103
Reply To: A Strange Comparison

Heh... you're such a "NOTty" boy! 😀 I haven't seen syntax like that in a very long time. Lot's of bloody != but incredibly little !< and !>.
--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)

October 26, 2020 at 2:14 am

#3801102
Reply To: SQL Server Phone Home

Sorry. I don't care if I'm not the actual owner of their software even if I've bought a license for it... they need to make turning such monitoring off a...
--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)

October 26, 2020 at 2:01 am

#3801101
Reply To: Having trouble with a BCP statement

itmasterw 60042 wrote:
I am running it in the edit window. I have done BCP here before but it was a long time ago. Do I need to rewrite this or some...
--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)

October 26, 2020 at 1:40 am

#3801099
Reply To: Having trouble with a BCP statement

itmasterw 60042 wrote:
I am running it in SSMS. the site I got this form seems to be doing it here, but I could be wrong.
If you're running the command from an...
--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)

October 25, 2020 at 6:43 pm

#3801040
Reply To: Having trouble with a BCP statement

PhilPacha wrote:
The double quote at the end of the SQL query ism't matched by a double quote at the beginning of the query. It isn't needed, anyway.
Actually, it is matched. ...
--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)

October 25, 2020 at 6:41 pm

#3801038
Reply To: Having trouble with a BCP statement

Step one is to look at your code and, using only the code for direction, tell me which database you want the code to run against. Yeah... I'm pretty sure...
--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)

October 24, 2020 at 11:00 pm

#3800808
Reply To: Poor peformance

Johan Bijnens wrote:
Jeff Moden wrote:
... They did start to talk about how Page Density is also important but not to any great extent (pun intended) 😀
I think the podcast should fit 1 hour...
--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)

October 23, 2020 at 2:29 pm

#3800459
Reply To: Killed SPID on xp_LogInfo not rolling back and growing TempDB

Mr. Brian Gale wrote:
Gotta love it when SQL can't guess how long the rollback will take so it tells you 0% and 0 seconds. I've seen that before and there is 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)

October 23, 2020 at 2:15 pm

#3800458
Reply To: Count the Number of Weekend Days between Two Dates

Jeffrey Williams wrote:
I was thinking more about this - realized we can do this:
SELECT weekend_day_count=y/7-x/7+(y+1)/7-(x-1)/7
FROM (VALUES(DATEDIFF(DAY,-53690,'1899-01-01') + 1,DATEDIFF(DAY,-53690,'1900-01-14') + 1))x(x,y)
We can specify the anchor date as 1753-01-01 (-53690) and then add...
--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)

October 23, 2020 at 12:34 pm

#3800414
Reply To: difference between two times
Just curious... where are the original "from" and "to" values coming from? I ask because, if we know that, we might be able to...
1. Strip a whole lot complexity from...
--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)
October 22, 2020 at 9:07 pm

#3800235
Reply To: Killed SPID on xp_LogInfo not rolling back and growing TempDB

Just a shot in then dark (which I can help with), does anything in the job make a call to xp_CmdShell?
--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)

October 22, 2020 at 8:27 pm

#3800221
Reply To: Backup taking too long - SQL Server 2016

PJ_SQL wrote:
We had the switch upgrade right before the backup started taking long time to finish.
I'm thinking that you've just identified your problem with the backups. 😉
Have the check 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)

October 21, 2020 at 9:48 pm

#3799883

Viewing 15 posts - 6,181 through 6,195 (of 59,072 total)