Forum Replies Created
Viewing 15 posts - 16,096 through 16,110 (of 59,067 total)
-
RE: Are the posted questions getting worse?
Grumpy DBA (12/16/2016)
Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family and friends for Christmas....--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) -
RE: Reindex DB on regular basis
Actually, I suggest NOT rebuilding indexes. As a part of a large experiment based on some videos by Brent Ozar, I haven't rebuilt indexes on my main prod box...
--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) -
RE: Results to new table
cboese (12/15/2016)
How can I insert into a new table (Table 3) The example below:Table 1 -
Column1
Texas
Oklahoma
Table 2 -
Column1
1
2
Table 3:
Column1 ...
--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) -
RE: Bitwise & NULL
Sioban Krzywicki (12/15/2016)
Jeff Moden (12/14/2016)
Sioban Krzywicki (12/14/2016)
What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?Who's going 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) -
RE: Bitwise & NULL
Sioban Krzywicki (12/14/2016)
What if the bitwise column never appears in the WHERE clause? What if all the values in the column are always returned?Who's going to read the column without...
--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) -
RE: Alternatives to Microsoft Certifications
patrick.w.wheeler (12/14/2016)
I proudly list my lone certificate on my resume in the summary and in the certification / educational section, now I have a complex.......Does listing a certification hurt 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) -
RE: Number of weeks between two dates
Rem70Rem (1/7/2011)
Well I found out that datediff seems to do what I was looking for.Thanks all for your help. Appreciated.
An essential part for the possible learning process...
--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) -
RE: Bitwise & NULL
CELKO (12/14/2016)
This is usually not a good design. For the painful details read this:https://www.simple-talk.com/sql/t-sql-programming/bit-of-a-problem/
I agree but you really need to stop writing WHERE clauses like this... 😉
WHERE DATEADD (YEAR, 18,...
--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) -
RE: Bitwise & NULL
drew.allen (12/13/2016)
You're already seeing some of the issues, in that you can't have three-value states.As previously stated, yes you can. 0, 1, or NULL. Yes, I realize 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) -
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/14/2016)
to be more clear, its a little bit more complicated as the print screen show :i can put under 10.20.12.0 (subnet 24) aagain same ip 10.20.12.0 (but with subnet...
--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) -
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/14/2016)
Jeff Moden there is some "bug"
15.11.0.0
15.3.0.0
should be under 15.0.0.0
how do i fix it?
The "bug" would be in whatever you did to the code I wrote or your presentation code...
--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) -
RE: House keeping projects for new year
JakDBA (12/13/2016)
Friends I am planning of doing some house keeping / eenhancements projects ... any suggestions ?? Version MSSQL 2014.Yes. Assuming that you've already ensured that backups are actually...
--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) -
RE: DBAs Need to Learn to Develop
Manie Verster (12/14/2016)
Ok, Jeff just do what is best for you but stay away from hammers please!!Heh... You know me... I never do what is best for me. 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) -
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
to be more clear this is an example of what i want to produce (the number in the square is the subnet selected)So take what I did and make...
--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) -
RE: Desing of a table and Hirerarchy - IP's
wanttolearn1 (12/13/2016)
Thanksi want the result to be in some hierarchy (this is after each ip "," followed by depth level
10.0.0.0,010.13.15.63,1
10.16.8.2,1
15.0.0.0,0
...
--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)
Viewing 15 posts - 16,096 through 16,110 (of 59,067 total)