Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,466 through 6,480 (of 59,101 total)

Reply To: unable to take backup

@Siten0308,
Did you ever figure out what your backup problem was and how to fix it?
--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 10, 2020 at 12:26 am

#3787442
Reply To: Retrieving the total number of records in a SQL instance

Jeff Moden wrote:
Ok... I have a question, especially seems to be coming up a lot lately.
To what end does someone need this type of information? What will the information ultimately be...
--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 10, 2020 at 12:22 am

#3787441
Reply To: SQL Script Help

Ram wrote:
thanks for highlighting the issue. i have fixed the code.
updated code available in below link.
https://pastebin.com/xUDYhF0r
Please post the code on this site, Ram... the content of pastebin could simply vanish...
--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 9, 2020 at 11:38 pm

#3787437
Reply To: Select unique records between several tables

I'm assuming that your tables are NOT named T01. T02, T03, etc and so I'm asking the following question again...
Jeff Moden wrote:
Is there a pattern to the actual name of the...
--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 9, 2020 at 8:54 pm

#3787423
Reply To: Complex Join
ScottPletcher wrote:
Jeff Moden wrote:
Sergiy wrote:
Still there is a shorter version:
```
select * 
from leftTable  T1
join rightTable T2 
   on (
      T1.C1...
```
--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 9, 2020 at 8:47 pm

#3787422
Reply To: Can't delete auto created statistics on SQL Server 2019

kaluza wrote:
Hi,
I'm have sysadmin rights but it is not possible for me to delete auto created statisitcs. I receive the message, that the statistic doesn't exits or I do not...
--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 9, 2020 at 8:44 pm

#3787421
Reply To: Formatting dates returned in query

Just in case you're not been able to find the reference for the formats...
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15
--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 9, 2020 at 8:39 pm

#3787420
Reply To: Do You Have Big Data?

Heh... to Sergiy's point, I wonder how many supposed "Big Data" problems are actually BIG "poor design", "poor implementation", "poor requirements", and "poor coding" problems. To wit, my definition 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 9, 2020 at 7:54 pm

#3787408
Reply To: Changing nvarchar to varchar

terry999 wrote:
Thanks Jeff and Sergiy for all your help.
I have a much better understanding now and have some design ideas: instead of triggers, partitioned views I can use not just...
--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 9, 2020 at 7:40 pm

#3787406
Reply To: remove lines from flat file with no header

It would probably help your cause a bit if you posted what several good and bad rows actually look like.
--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 9, 2020 at 7:38 pm

#3787405
Reply To: Complex Join
Sergiy wrote:
Still there is a shorter version:
```
select * 
from leftTable  T1
join rightTable T2 
   on (
      T1.C1 = T2.C1...
```
--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 9, 2020 at 7:35 pm

#3787404
Reply To: Extended Event collect sql text executed

Erland Sommarskog wrote:
(Well, I tend to think that it works better in any version given how much easier Trace is to use, but that is another story.)
It's too bad 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)

September 9, 2020 at 5:03 pm

#3787373
Reply To: Select unique records between several tables

Is there a pattern to the actual name of the tables and are all of the tables in the same database?
--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 9, 2020 at 5:01 pm

#3787369
Reply To: how to get Pivot result set using 3 tables

Erland Sommarskog wrote:
Jeff, he has already answered which version he has: SQL Express 2012 SP1. (So, Gaurav, you should apply the latest Service Pack for SQL 2012, which is SP4!)
Thanks, Erland......
--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 9, 2020 at 4:54 pm

#3787364
Reply To: Changing nvarchar to varchar

p.s. I you do decide to move the table (whether you turn it into a partitioned view or not), you should keep the original table for a couple of weeks...
--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 9, 2020 at 1:54 pm

#3787324

Viewing 15 posts - 6,466 through 6,480 (of 59,101 total)