Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,651 through 4,665 (of 59,101 total)

Reply To: Capture login information

Here's a link about things that you can to do with login triggers and the like. One of the things is to audit logins.
https://www.sqlshack.com/an-overview-of-logon-triggers-in-sql-server/
Note that if you're doing this...
--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)

September 20, 2021 at 5:08 am

#3931041
Reply To: Find all SPs, FNs, and VWs where particular string occurs

VoldemarG wrote:
I have this task to find all SPs, FNs, and VWs where particular string occurs in definition of the object. In 300 databases in a huge server.
How do you...
--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)

September 20, 2021 at 4:56 am

#3931038
Reply To: What is the specific job of the SQL Developer position?

Unless this is a prelude to SPAM, your post is a bit contradictory. You say you read a job description and also say that that it matches your abilities 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)

September 19, 2021 at 12:10 am

#3930870
Reply To: Execute sql task behave differently when run in isolation versus part of package

Thanks for the feedback, Dave.
--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)

September 18, 2021 at 11:54 pm

#3930866
Reply To: GUIDs as clustered index

Just as an update, please see the following presentation where I destroy the myth of Random GUID Fragmentation and pretty much waste what people have been using as supposed "Best...
--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)

September 18, 2021 at 2:24 am

#3930752
Reply To: Rebuild index

At $7K per core for such a license and the number of cores you have, you should spend a relatively tiny bit more and get yourself up to 512GB of...
--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)

September 17, 2021 at 8:26 pm

#3930681
Reply To: There is insufficient sys memory in resource pool 'internal' to run this query

Spot on, Grant. Especially with only 12GB of RAM available.
--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)

September 17, 2021 at 8:16 pm

#3930679
Reply To: How to grant Exec ON multiple Stored Procedures

Ah... didn't see Mike post while I was typing. I also meant to say that once you're sure the code it produces is correct, change the PRINT @sql to EXEC...
--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)

September 17, 2021 at 8:10 pm

#3930676
Reply To: How to grant Exec ON multiple Stored Procedures

As Grant suggests, the use of Dynamic SQL would be the ticket here. Use a pattern search (LIKE) on the names of stored procedures in the sys.procedures system view to...
--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)

September 17, 2021 at 8:08 pm

#3930674
Reply To: Implicit conversion on hash key column is causes very slow insert

@frederico_fonseca ,
You should write a short article on the NULL/Empty String collision problem you pointed out to me. It's a great catch.

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

September 17, 2021 at 2:18 am

#3930363
Reply To: Restore all Databases in a Directory

Just in case anyone is interested in this script, the latest upgrade to the software on this site broke the link in the first post and it will take you...
--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)

September 16, 2021 at 10:47 pm

#3930329
Reply To: Rebuild index

Chitown wrote:
I have a table which is partitioned (Total 10). The table is 1.6 TB in size. Rebuild index on that is quite challenging, especially we have some resource constraints....
--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)

September 16, 2021 at 10:30 pm

#3930328
Reply To: Parsing XML data

Just as a sidebar in personal frustration, XML never ceases to amaze me in its inefficiencies. The original XML in the original post occupies 244 characters. Even if you convert...
--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)

September 16, 2021 at 10:24 pm

#3930327
Reply To: SQL StoredProcedure for data validation using REGEX in SSIS

I'll also state that RegEx is serious overkill for the type of validations you've described. You certainly don't need CLR, either. The example the ratback provided above will work quite...
--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)

September 16, 2021 at 9:47 pm

#3930315
Reply To: Attach DB without FileTable folder

Thanks for the feedback, Mike. You're the second person I've heard of (I'm sure there are more that I haven't) that had the backups encrypted by ransomware. I think 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)

September 16, 2021 at 5:20 am

#3930028

Viewing 15 posts - 4,651 through 4,665 (of 59,101 total)