Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,131 through 14,145 (of 59,101 total)

RE: query format

MinhL7 - Wednesday, October 11, 2017 6:48 PM
They're grouped

CREATE TABLE [dbo].[Title]( [ID] [int] NULL,
[Description] [varchar](50) NULL,
[Dept] [varchar](50) NULL
) ON...
--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)

October 11, 2017 at 7:56 pm

#1963293
RE: What Pizzas do DBA's prefer?

My mom used to make a thing called "Upside Down Pineapple Pizza". It wasn't a tomato and cheese based pizza. It was more like a dessert and, man, it made...
--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)

October 11, 2017 at 2:38 pm

#1963275
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

Great. My next question is, have you actually tested in your environment to see if compression is actually going to help? On the few large tables I've tested in my...
--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)

October 11, 2017 at 2:35 pm

#1963273
RE: What Pizzas do DBA's prefer?

smallmoney - Wednesday, October 11, 2017 2:02 PM
I prefer Pepperoni Lovers from Pizza Hut
I prefer OPBI... "Other People Bought 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)

October 11, 2017 at 2:16 pm

#1963264
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

Why couldn't you just use the same method played against a table of results generated by the first run to control which columns get compressed?
Another search will scare 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)

October 11, 2017 at 2:09 pm

#1963263
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

Tons. See the following link, which will also teach another essential skill in the process.
http://bfy.tw/EQFy
--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)

October 11, 2017 at 1:13 pm

#1963249
RE: Smalldatetime

Stewart "Arturius" Campbell - Tuesday, October 10, 2017 1:16 AM
Nice one, thanks Steve
even though Microsoft themselves recommend using the new date/time formats...
--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)

October 11, 2017 at 9:10 am

#1963203
RE: Grouping Multiple Lines to One

nicolestrain07 - Wednesday, October 11, 2017 2:43 AM
Hello,
Im trying to combine multiple lines to one like the below example.
I looked at...
--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)

October 11, 2017 at 8:57 am

#1963198
RE: query format

MinhL7 - Wednesday, October 11, 2017 6:00 AM
Jeff Moden - Sunday, October 8, 2017 11:45 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)

October 11, 2017 at 8:32 am

#1963193
RE: Options to run BCP in SQL Server

sqlenthu 89358 - Tuesday, October 10, 2017 11:17 AM
Guys, I am little confused here w.r.t. permissions. When I tried BCP load from...
--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)

October 10, 2017 at 11:22 am

#1963092
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AM
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
Wow! Just ... WOW! ...
--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)

October 10, 2017 at 11:14 am

#1963083
RE: Alter LDF File Max Size

Chris Harshman - Tuesday, October 10, 2017 10:12 AM
jstites - Monday, October 9, 2017 4:54 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)

October 10, 2017 at 10:48 am

#1963074
RE: Fun Conversions

Ed Wagner - Tuesday, October 10, 2017 5:24 AM
I remember the thread this question came from. It made an excellent QOTD.
Bwaa-haaa!!! Thank...
--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)

October 10, 2017 at 5:47 am

#1962979
RE: Reversing visibility of spam forum threads

There is a definite pattern to most of the spam posts... I don't understand why their spam detector hasn't learned from all the spam reports.
I've stopped reporting...
--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)

October 10, 2017 at 5:38 am

#1962977
RE: Stored procedure is taking too long to execute.

It's not possible to troubleshoot such a stored procedure without the correct information. Please see the second link in my signature line below under "Helpful Links" for the right 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)

October 9, 2017 at 5:49 pm

#1962924

Viewing 15 posts - 14,131 through 14,145 (of 59,101 total)