Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 59,069 total)

Reply To: How can i give Grant permission for synonyms from another database in same server.

Brandie Tarvin wrote:
But why would you need synonyms on the same server? It's easy enough for users just to use Database.Schema.Table conventions in their code, isn't it?
You'll just love...
--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)

December 14, 2021 at 12:39 am

#3963294
Reply To: Arithmetic overflow error converting expression to data type smallint

water490 wrote:
Hi everyone
I am getting error
Arithmetic overflow error converting expression to data type smallint
The calculation I am doing is producing very small numbers like 0.0000005328.
How can I fix the calculation...
--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)

December 13, 2021 at 7:34 pm

#3963203
Reply To: invoke-sqlcmd : Cannot open database requested by the login. login. Login failed

Why are you doing this in PowerShell?
--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)

December 13, 2021 at 7:29 pm

#3963198
Reply To: permissions

ScottPletcher wrote:
An "audit" that only allows what the DBA wants to run is not a true audit.
Correct. That's why I have them witness the runs. And, as a DBA, 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)

December 13, 2021 at 7:22 pm

#3963196
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format

DaveBriCam wrote:
What format would you prefer the data?
READ THE ARTICLE AND YOU'LL KNOW AS LEAST ONE WAY!
--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)

December 13, 2021 at 6:56 pm

#3963184
Reply To: Filtering/ searching in forum topics?

Helene Kastor wrote:
We need a reference value to see which scripts has a high popularity because we didnt want to search in more than thousand scripts. We only want the scripts...
--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)

December 13, 2021 at 6:52 pm

#3963183
Reply To: SQL Server Execution Plans, Third Edition, by Grant Fritchey

Grant Fritchey wrote:
Jeff Moden wrote:
Grant,
Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?
No plans to update the execution plans book...
--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)

December 13, 2021 at 6:40 pm

#3963178
Reply To: queries running during the sql backup

Grant Fritchey wrote:
When a backup starts, a marker is placed in the transaction log. Any transactions that are completed when the backup is done, are then backed up. Any transactions 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)

December 13, 2021 at 6:39 pm

#3963176
Reply To: One to many SQL Server books

Eric M Russell wrote:
Jeff Moden wrote:
Thanks for taking the time to write this article, Kathi.
What's even worse than what you mention is that the quality of the "official" documentation has totally tanked as...
--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)

December 13, 2021 at 6:36 pm

#3963174
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format
DaveBriCam wrote:
```
-- here are the basic DDLs for my two tables:

CREATE TABLE [portman].[dbo].[AgentHours](
[LoginEntryID] [int] IDENTITY(1,1) NOT NULL,
[DOMAIN] [varchar](4) NOT NULL,
[DATE] [date] NOT NULL,
[LOGIN TIMESTAMP] [datetime2](0) NULL,
[LOGOUT TIMESTAMP]...
```
--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)
December 13, 2021 at 6:28 pm

#3963168
Reply To: SQL Server Execution Plans, Third Edition, by Grant Fritchey

Grant,
Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?

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

December 13, 2021 at 12:28 am

#3962902
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
I was having a look at some of the raw files to upload to the tables and realised that I missed pointing out that some of the source files...
--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)

December 12, 2021 at 11:52 pm

#3962895
Reply To: Loading x number of CSV files into x number of unique tables of a database

masterelaichi wrote:
Thanks, Jeff. Truly appreciate your help with this!
The only thing that I remembered was that the files were built from Excel files. What I didn't remember was that 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)

December 12, 2021 at 11:46 pm

#3962894
Reply To: SQL Server 2016 to 2019 now SSRS Cannot create a connection to data source

Did you update your SSRS and migrate your reports, 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)

December 11, 2021 at 11:48 pm

#3962758
Reply To: Loading x number of CSV files into x number of unique tables of a database

I finally had a decent bit of time to start working on this and went back through all of the comments to refresh my memory. I first came across 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)

December 11, 2021 at 11:24 pm

#3962757

Viewing 15 posts - 4,216 through 4,230 (of 59,069 total)