Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 66,061 through 66,075 (of 66,738 total)

You must be logged in to reply to this topic. Login to reply

jasona.work SSC Guru Points: 50118 More actions · Answer 1

I know this is a "why the heck didn't you have that stuff scripted out before, anyways" sort of situation, and you'd be right...

Just discovered today, working with a customer to get their Agent jobs set back up in our new Test environment that, well, the illustrious DBA (me) didn't script out their proxies, the credentials for same, or their DBMail profiles and operators...

Now, in my defense, we had 30 days to migrate all of production and all of test (SQL, web, other applications, lord only knows how many outside connections of various types including linked servers) so it was rather chaotic during this migration.

And it should say something that it's been almost 5 months since the migration wrapped up that we're still working on getting our test environment up and running. Heck, the devs STILL have limited access to test because of things the hosting provider is STILL trying to complete / get them to fix.

Great way to start heading into a week off (well, OK, I still work tomorrow and now I've got my project for the day, but still)

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 2

Just in case anyone else is having the issue... I've verified that I'm no longer getting email responses for posts that I've subscribed to or have responded to. I've send a notification to webmaster@sqlservercentral.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)

Eirikur Eiriksson SSC Guru Points: 182916 More actions · Answer 3

Jeff Moden wrote:

Just in case anyone else is having the issue... I've verified that I'm no longer getting email responses for posts that I've subscribed to or have responded to. I've send a notification to webmaster@sqlservercentral.com .

Same here, last email notification I got was on the 26th of October.

😎

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 4

Thanks for the reply, Eirikur.

--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)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

Eirikur Eiriksson wrote:

Jeff Moden wrote:
Just in case anyone else is having the issue... I've verified that I'm no longer getting email responses for posts that I've subscribed to or have responded to. I've send a notification to webmaster@sqlservercentral.com .
Same here, last email notification I got was on the 26th of October. 😎

Same here. I've seen no notifications at all recently. This isn't the first time the notifications died - someone will notice and fix it.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 6

I'm thinking that they've stretched Steve a bit too far... I can't even get an acknowledgment to the two emails that I've sent the WebMaster about the email notifications.

--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)

Eirikur Eiriksson SSC Guru Points: 182916 More actions · Answer 7

Jeff Moden wrote:

I'm thinking that they've stretched Steve a bit too far... I can't even get an acknowledgment to the two emails that I've sent the WebMaster about the email notifications.

Just bumping the notification issue although I understand that bumping is kind of useless without the notification service not working 🙁

😎

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 8

@Webmaster finally responded. It turns out that Steve Jones is no longer the "watcher" there. I got a hold of Steve through his email and he said they'd notify the folks that are supposed to be watching and he did. I got a notification back from a human there and they asked if anyone else was experiencing the problem. I notice that Phil Parkin posted on the "Website Issues" about 2 weeks ago and he had no joy there. You also recently posted there. I hope they start watching that, as well.

--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)

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 9

Ok... they've fixed the notifications issue and it appears have been doing things correctly for a while now. Does anyone have any more problems with that issue?

--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)

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 10

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update the columns that were actually updated? I've not been able to find hide nor hair of 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)

Steve Collins SSCrazy Points: 2174 More actions · Answer 11

Jeff Moden wrote:

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update the columns that were actually updated? I've not been able to find hide nor hair of one.

Why not its own topic? The examples I found are from when there's an insert into a view and then an INSTEAD OF trigger handles denormalization (iirc and afaik). The code is from something I would have to refresh my memory. Maybe it's helpful?

create or alter trigger dbo.trg_authorization_policies_hierarchy_vw_insert
on dbo.authorization_policies_hierarchy_vw
instead of insert
as
declare
  @aup                  table(aup_id            bigint primary key not null,
                              policy_name       nvarchar(140) unique not null);

insert dbo.authorization_policies(pshp_id, policy_id, policy_name, created_dt)
output inserted.aup_id, inserted.policy_name into @aup
select pshp_id, policy_id, policy_name, created_dt
from inserted;

insert dbo.authorization_policies_by_hierarchy(aup_id, hierarchy, created_dt)
select aup.aup_id, i.hierarchy, sysutcdatetime()
from @aup aup
     join inserted i on aup.policy_name=i.policy_name;
go

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 12

Steve Collins wrote:

Jeff Moden wrote:
SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update the columns that were actually updated? I've not been able to find hide nor hair of one.
Why not its own topic? The examples I found are from when there's an insert into a view and then an INSTEAD OF trigger handles denormalization (iirc and afaik). The code is from something I would have to refresh my memory. Maybe it's helpful?
create or alter trigger dbo.trg_authorization_policies_hierarchy_vw_insert
on dbo.authorization_policies_hierarchy_vw
instead of insert
as
declare
  @aup                  table(aup_id            bigint primary key not null,
                              policy_name       nvarchar(140) unique not null);

insert dbo.authorization_policies(pshp_id, policy_id, policy_name, created_dt)
output inserted.aup_id, inserted.policy_name into @aup
select pshp_id, policy_id, policy_name, created_dt
from inserted;

insert dbo.authorization_policies_by_hierarchy(aup_id, hierarchy, created_dt)
select aup.aup_id, i.hierarchy, sysutcdatetime()
from @aup aup
     join inserted i on aup.policy_name=i.policy_name;
go

I have no issues with Instead of Insert. Those are easy, just like you posted. I'm trying to build an Instead of UPDATE that only updates the column that were actually updated so it won't fire any other "after" triggers that shouldn't fire.

As a bit of a sidebar, the tables I'm working with are quite wide. Dynamic SQL will not "see" the logical INSERTED and UPDATED pseudo tables. In the past, people have posted code that does a SELECT INTO a Temp table from the logical tables but that makes things horribly slow, especially for these wide 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)

Steve Collins SSCrazy Points: 2174 More actions · Answer 13

TRIGGER_NESTLEVEL? I usually try to persuade novices out of it. Maybe the non-INSTEAD OF triggers could ask themselves: "Have I been executed at an inappropriate nest level?"

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 14

Thanks, Steve.

It's a tougher question than I thought.

All I want to do is add an Instead Of Update trigger to a table, do a small task, and then do an actual update to only the original columns that were updated. That's a PITA because the Inserted and Updated objects are not available in Dynamic SQL and it takes too long to copy all the rows from the Inserted and Updated objects to a temp table or two and I have no issues with figuring out which columns were updated and...

... I've never seen anyone or any code that will do such a thing and, so far, I can only do it with the temp table thing. Hmmm... I wonder if a Temp Stored Procedure might work.

--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)

DesNorton SSC-Insane Points: 24401 More actions · Answer 15

Your fingers might get considerably shorter, but you could always add a lot of these ...

IF UPDATE (colName )
BEGIN
  -- Add your column to DSQL ...
END;

How to post data/code on a forum to get the best help.