Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 59,067 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more...
--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)

April 1, 2022 at 3:39 pm

#4009394
Reply To: Connect to a SQL Server through a proxy

evald wrote:
i used th ewindows built-in proxy and it works great!

Thanks for posting the solution that you found for your own question. It's going to help others, for 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)

April 1, 2022 at 3:31 pm

#4009391
Reply To: Temp Tables question
rjjh78 wrote:
Is it possible to create a temp table when setting a query?
For example:
```
DECLARE 
@Category    varchar(100), 
@SubCategory varchar(100),
@Query      ...
```
--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)
April 1, 2022 at 3:19 pm

#4009386
Reply To: Best way to add last 4 of SSN to data feed in SSIS from encrypted SSN column

TangoVictor wrote:
Nevermind - It's too bad there's not a delete option for posts.
What did you end up doing to solve your problem?
--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)

April 1, 2022 at 3:11 pm

#4009382
Reply To: Query tuning advice

Doing only a quick glance at the execution plans, this looks like it could be a parameter sniffing issue. You could go all surgical on this but I'm thinking 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)

March 30, 2022 at 3:27 pm

#4008289
Reply To: The Level of Security These Days

david.edwards 76768 wrote:
I like that chart Jeff, I might add it to my favourite argument I trot out every time I am faced with a short password requirement that forces numbers,...
--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 29, 2022 at 4:10 pm

#4007718
Reply To: Scalability in SQL and NoSQL?

Grant is spot on but I'll add an "old dude's" take on it...
Which ever turns out to be the best "architecture" for your data, none of it will matter 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)

March 29, 2022 at 4:01 pm

#4007717
Reply To: Magic Tables in the SQL Server

It's amazing to me how much incorrect information there is posted in posts containing a list of interview questions.
My recommendation to people using such lists is to only look at...
--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 29, 2022 at 3:51 pm

#4007715
Reply To: Slow SQL Server Performance PAGEIOLATCH_SH, CXPACKET help!

csteeeetr wrote:
Hi All,
(see attached waits) I have a very slow sql server, it seemed to happen over night and queries are still slow. index rebuild/reorg and statistics have been updated....
--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 29, 2022 at 3:34 pm

#4007711
Reply To: Create 1 calendar for each student

bravocharlie wrote:
It's looking great right now, sample attached with redactions.
I kept cteCalendar as you designed it, and changed ctePreCrossTab to use my attendance table.
It correctly merges the data correctly, 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)

March 29, 2022 at 3:11 pm

#4007708
Reply To: Trigger: Need help to save activity log on delete

ScottPletcher wrote:
As to putting FKs on an audit table... don't EVER do that. There's not reason to because the rows have already survived the INSERTs and UPDATEs for FKs 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 28, 2022 at 9:06 pm

#4007312
Reply To: Create 1 calendar for each student

bravocharlie wrote:
3) I created a quick table in SSRS and sure enough, it does depict a calendar style matrix with the month dates and the value in ##Attendance (screen snip...
--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 28, 2022 at 5:25 pm

#4007206
Reply To: Trigger: Need help to save activity log on delete

Steve Collins wrote:
Jeff Moden wrote:
A default value doesn't do an update once the entry is populated by a default and it needs to change with every action.
The trigger "prevents" (assuming...
--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 28, 2022 at 4:52 pm

#4007190
Reply To: Bulk Insert Truncation and Try Catch

Most people won't even try it because it uses xp_CmdShell but if you use it to call SQLCmd to do the same thing and capture the output of the 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)

March 28, 2022 at 5:48 am

#4006863
Reply To: Trigger: Need help to save activity log on delete

As a bit of a sidebar, the "poor man's" method of auditing that includes a variable width NVARCHAR or VARCHAR column to store the name of the person or thing...
--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 28, 2022 at 2:24 am

#4006810

Viewing 15 posts - 3,691 through 3,705 (of 59,067 total)