Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,211 through 18,225 (of 59,102 total)

RE: HEX conversions

Ed Wagner (2/23/2016)
I've helped several people at work where they just couldn't figure out why something so simple wasn't working and it turned out that they used varchar variables with...
--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 8, 2016 at 5:23 pm

#1863889
RE: Partitioning with null column

er.mayankshukla (3/7/2016)
Alter the column to non-nullable
That's the right idea but they also need to ensure that the data in the partitioning column will NOT change... EVER. 😉
--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 8, 2016 at 10:34 am

#1863765
RE: error during shrink file after restore on test

tony28 (3/7/2016)
thanks for the reply.. I am not sure if somebody knows what I want...so sorry for my english
Because this is test server and data will 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)

March 7, 2016 at 3:27 pm

#1863583
RE: Query/Performance Tuning Steps without help of profiler

Grant Fritchey (3/7/2016)
The main thing is that there are no additional trace events being added.
BWAAA-HAAAA-HAAA!!!! That means that it's finally stable! 😀
--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 7, 2016 at 12:20 pm

#1863536
RE: Query/Performance Tuning Steps without help of profiler

Grant Fritchey (3/7/2016)
You shouldn't be using Profiler anyway. Instead, use extended events.
Heh... I strongly agree... to disagree. 😛 Maybe it's just the bad taste in my mouth left...
--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 7, 2016 at 8:05 am

#1863476
RE: how to loop without endless joins

astrid 69000 (3/7/2016)
Hi,
Sorry it took me long to answer.
First of all, thanks to everyone who took the time to help.
I have read and part I did understand, part I didn't....
--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 7, 2016 at 7:55 am

#1863469
RE: how to loop without endless joins

Ed Wagner (3/7/2016)
He changed the data type to allow extra space for the concatenation to occur. Try changing both VARBINARY(1000) to a BINARY(4) and run it to see 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)

March 7, 2016 at 7:49 am

#1863466
RE: error during shrink file after restore on test

tony28 (3/5/2016)
Hello,
I did backup and restored to test..
bak file has about 13GB.
database has allocated mdf file for 40GB and log file for 5GB... I wanted shrink this mdf, because there...
--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 6, 2016 at 7:24 pm

#1863388
RE: Partitioning with null column

RUNNERSQL (3/6/2016)
yes, we realized later that we did the partitiotion on nullable column.
Do we need to make it to notnull and redo the partitiotion ? OR any other options...
--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 6, 2016 at 6:15 pm

#1863386
RE: Partitioning with null column

RUNNERSQL (3/6/2016)
Hi,
we have partitioned a table based a column datatype 'null'.
we have partitions created on all non-clustered indexes.And we didn’t create the partition column in the primary...
--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 6, 2016 at 4:35 pm

#1863384
RE: Departments, Teams, Roles and Services

Hugo Kornelis (3/2/2016)
First, thanks for not including surrogate keys in your ERD. They are an implementation choice, so they should never ever be in any ERD.
That's one opinion. ...
--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 6, 2016 at 4:25 pm

#1863383
RE: Query/Performance Tuning Steps without help of profiler

Eirikur Eiriksson (3/6/2016)
ganapathy.arvindan (3/6/2016)
Please Help me Query/Performance Tuning Steps with out help of profiler
Quick suggestion, get Grant's book on execution plans[/url]
😎
+1 Million to that. Profiler can help but 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)

March 6, 2016 at 4:12 pm

#1863382
RE: generate unique id for each row within a range

Sergiy (3/6/2016)
bismsit.29 (3/3/2016)
Hi Alan,
Thank you very much for replying back so early.
Its sort of a business requirement that's why i want to reuse them also this value can hold till...
--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 6, 2016 at 3:35 pm

#1863381
RE: generate unique id for each row within a range

@bismit29,
I still need answers to the questions in my last post so that I or anyone else can help you wrap this up.
--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 6, 2016 at 3:33 pm

#1863380
RE: Selecting data from GUI in msdb

Ed Wagner (3/4/2016)
This has nothing to do with the question that's already been answered.
Actually, I wonder if the question has been answered. 🙂
I wonder if it's a "security" feature kind...
--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 5, 2016 at 6:39 am

#1863321

Viewing 15 posts - 18,211 through 18,225 (of 59,102 total)