Forum Replies Created
Viewing 15 posts - 11,611 through 11,625 (of 59,102 total)
-
RE: Adding Indexes to Tables
Grant Fritchey - Tuesday, August 7, 2018 6:24 AMrjjh78 - Monday, August 6, 2018 3:52 PMRE: formatting T-SQL
andycadley - Tuesday, August 7, 2018 6:29 AMLuis Cazares - Monday, August 6, 2018 11:25 AMRE: Archiving when 2 tables are sharing the same partition scheme and same partition function
Thanks for the feedback on my comment.
Shifting gears a bit, I've found that partitioned tables are pretty annoying compared to partitioned views. I can do everything I can...
--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: Representing XML data in SQL Server
This is a nicely written article. Just as a suggestion for future articles, it would have been great if you identified where you got the Sales and SaleItems data from or...
--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: Rows into dynamic columns
Nicely documented, Jason. You should write articles.
--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: SQL Database Documentation
Charles_P - Monday, August 6, 2018 9:21 PM--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: SQL Database Documentation
Tim,
I don't know about anyone else but that came out looking like a very strange language. Not sure what font you uses but there's a one to one character...--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: A "safe" replacement for xp_CmdShell - for test purposes
Jeff Moden - Monday, August 6, 2018 6:14 AMglen205 - Monday, August 6, 2018 3:34 AMRE: Delete and shrink data file
WhiteLotus - Monday, August 6, 2018 9:19 PMJeff Moden - Monday, August 6, 2018 9:11 PMRE: Delete and shrink data file
Yes. The space within the data file for that database will be reused by that database to hold ne data without growing... provided that you've actually deleted whole pages OR...
--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: REPLACE Multiple Spaces with One
STRING_AGG (Transact-SQL)
<!-- -->THIS TOPIC APPLIES TO:
SQL Server (starting with 2017)It's not available in SQL Server...
--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: Archiving when 2 tables are sharing the same partition scheme and same partition function
I don't know why what you said happened actually happened but I'd take it as a lesson learned and have two different partition schemes. I've not run into the problem...
--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: Adding Indexes to Tables
rjjh78 - Monday, August 6, 2018 3:52 PM--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: A Stairway series on Performance Tuning would be amazing!
Here's an example post of what a "tuning series" might actually start with.
https://www.sqlservercentral.com/Forums/1983195/Adding-Indexes-to-TablesNo... not volunteering... I still have way too much on my plate 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)RE: hashbytes
IF that's the case and understanding that
mahnj18 - Monday, August 6, 2018 3:56 PM--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 - 11,611 through 11,625 (of 59,102 total)
SQL Server (starting with 2017)