Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 59,089 total)

Reply To: How to Structure Data table/fields when using Multiple Select Drop Down

Jonathan AC Roberts wrote:
Your database is not normalised.
The standard way to store this is to have two tables instead of your #u table
It's a work table, Jonathan.
--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)

March 13, 2021 at 10:37 pm

#3857445
Reply To: Distributed SQL Databases

Heh... my observation has been that a lot of people think they need to scale out but, in truth, it's because of bad database design, improper use of ORMs, 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)

March 13, 2021 at 10:35 pm

#3857444
Reply To: How to Structure Data table/fields when using Multiple Select Drop Down

Ok... if we're going to go "there", then why doesn't the front-end where the "pull-down" lives do this and occasionally upload from the Fruit table to keep it in synch? ...
--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)

March 13, 2021 at 10:27 pm

#3857441
Reply To: Ransomware trojan enters via Powershell script contained in Word macros

wrote:
CryptoLocker ransomware or similar malware is distributed through spam email campaign. Scammers or attackers send spam emails in your mail box which contain messages along with malicious attachments 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)

March 13, 2021 at 6:58 pm

#3857408
Reply To: How to Structure Data table/fields when using Multiple Select Drop Down

Ah... sorry... you can read the article about how the DelimitedSplit8K function works at the following article...
https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function
... and a serious performance enhancement to the code by Eirikur Eiriksson 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)

March 13, 2021 at 5:38 pm

#3857389
Reply To: How to Structure Data table/fields when using Multiple Select Drop Down

It would be a lot easier to do using STRING_AGG() in SQL Server 2017 and up but, since this is a 2014 thread, we'll have to do it the old...
--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)

March 13, 2021 at 5:33 pm

#3857388
Reply To: Bulk Insert not working for dataset

sudishnch wrote:
BULK INSERT #CUSTOMER FROM 'E:\Loyalty_DWND\A22679.csv' WITH ( FIRSTROW=2, --DATAFILETYPE = 'char', FIELDTERMINATOR =',', ROWTERMINATOR = '0x0a', -- CODEPAGE = '65001', TABLOCK, FIELDQUOTE='"', FORMAT='CSV'
)
That would do the trick in 2017...
--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)

March 13, 2021 at 3:59 pm

#3857361
Reply To: parse files in folder

Bruin wrote:
The above lookups are in the 1st record in file using criteria above. I need some help ...
THanks.
What's stopping you from reading the first two rows using Bulk 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)

March 13, 2021 at 2:46 am

#3857197
Reply To: Clone a table from a script

maylar wrote:
Yeah, I want just the schema. But how do I import the sql file into the database to create a new table?
Bulk Insert the text file as a single...
--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)

March 13, 2021 at 2:37 am

#3857195
Reply To: How to delete child records from table tradecode that not have parent on tradeco

jcelko212 32090 wrote:
The proprietary identity table property is not an attribute by definition, so it can never be a key. But it is let's bad programmers write their SQL as if...
--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)

March 12, 2021 at 1:27 am

#3856743
Reply To: Excessive Blocking despite Read Committed Snapshot Isolation

Leo.Miller wrote:
I've got a DynamicsAX database that's seeing a significant amount of blocking despite having RCSI set and the connections using Read Committed.
Aren't most of the Clustered Indexes in DynamicsAX...
--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)

March 11, 2021 at 7:44 pm

#3856654
Reply To: Name of the remote server in a query

Ross McMicken wrote:
Jeff Moden wrote:
Ram wrote:
My thanks to Jeff, Voldemar and Scott.
@jeff, I was thinking of getting the remote server name through some variable or a function in remote server while I...
--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)

March 8, 2021 at 7:43 pm

#3855086
Reply To: Server identification

p.s. Just noticed that they also list the old command of "SQLCMD -L" to find servers. I discovered very long ago that if the SQL Browser service on a server...
--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)

March 8, 2021 at 4:20 pm

#3855004
Reply To: Server identification

Sometimes, you've just gotta love the internet search capabilities. Check out the following Google search for what you seek.
https://www.google.com/search?q=powershell+to+find+all+sql+server+servers+in+a+domain&oq=powershell+to+find+all+sql+server+servers+in+a+domain
--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)

March 8, 2021 at 4:16 pm

#3855003
Reply To: Server identification

mtz676 wrote:
Hello @jeff,
We use MAPS to collect SQL inventory from all servers, but MAPS cannot be automated.Are there any other free tools which can scan our network periodicaly and identify...
--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)

March 8, 2021 at 3:52 pm

#3855000

Viewing 15 posts - 5,521 through 5,535 (of 59,089 total)