Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,191 through 26,205 (of 59,099 total)

RE: Today's Random Word!

Retrofit (wishful thinking).
--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)

August 16, 2013 at 11:16 am

#1642277
RE: Are the posted questions getting worse?

Grant Fritchey (8/16/2013)
Paul White (8/15/2013)
Jeff Moden (8/15/2013)
While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level...
--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)

August 16, 2013 at 11:14 am

#1642276
RE: Are the posted questions getting worse?

Paul White (8/15/2013)
Jeff Moden (8/15/2013)
While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an...
--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)

August 16, 2013 at 11:04 am

#1642272
RE: Are the posted questions getting worse?

I'm prepping a table, which has gotten kind of large, for partitioning. While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild...
--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)

August 15, 2013 at 8:27 pm

#1641967
RE: Generate N sequential numbers (fast)

Steven Willis (6/22/2013)
Brian
It looks like you have a winner! I ran a test of DelimitedSplit8K using your method against 3 other methods including the Itzik Ben-Gan method. Your version consistently...
--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)

August 15, 2013 at 4:51 pm

#1641951
RE: Log Space % increases while size stays the same

agordon 35530 (8/15/2013)
The only backups that run are the ones that I run manually and the automated backup at 11 PM. I created a maintenance plan yesterday to automate...
--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)

August 15, 2013 at 4:13 pm

#1641946
RE: How to Compile, Deploy and Consume a SQL Server CLR Assembly

chillsdon (8/14/2013)
Try making the database trustworthy first:
ALTER DATABASE <DBName> SET TRUSTWORTHY ON
I had to do this when creating a CLR procedure that accessed the file system, and so then also...
--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)

August 15, 2013 at 6:50 am

#1641778
RE: How to Compile, Deploy and Consume a SQL Server CLR Assembly

Stan Kulp-439977 (8/14/2013)
I know that encryption is natively available in SQL Server.
I just wanted to demonstrate a non-trivial use of a CLR assembly, and I just happened to have...
--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)

August 15, 2013 at 6:43 am

#1641772
RE: How to Compile, Deploy and Consume a SQL Server CLR Assembly

Chris Harshman (8/13/2013)
Jeff Moden (8/13/2013)
Outstanding step by step article but (to cover the headline) I'm pretty sure that encryption and decryption Is possible in SQL Server. 🙂
While it's possible 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)

August 15, 2013 at 6:42 am

#1641770
RE: Log Space % increases while size stays the same

Steve Jones - SSC Editor (8/15/2013)
Are you sure a log backup didn't run in that 10 minutes? That would explain it.
Agreed.
Now the only problem as to why a 15,000MB log...
--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)

August 15, 2013 at 6:34 am

#1641765
RE: Is this a "gaps and islands" problem? Finding gaps in overlapping times.

ChrisM@Work (8/15/2013)
Dwain's quite capable of providing an American English description of how his code works. Here's an English description of mine 😀
BWAAAA-HAAAA!!!! I'm not sure that's so true anymore. ...
--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)

August 15, 2013 at 6:28 am

#1641763
RE: Virtual tally table function

Speaking of rocks, I feel like a rock because I totally missed this script entry. Thanks for the kudos, Steven, but I can't claim this method as my original...
--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)

August 15, 2013 at 6:17 am

#1641756
RE: Is this a "gaps and islands" problem? Finding gaps in overlapping times.

GPO (8/15/2013)
Awesome to have the heavy hitters on the case! Jeff, where you say:
You're not actually supposed to use any data from that. You're only supposed to use the presence...
--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)

August 15, 2013 at 6:06 am

#1641750
RE: Put 4 tables in 1 table.. HOW to do that?

HanShi (8/15/2013)
Does this statement work?
CREATE VIEW v_WhatsUp_Assyst
AS
SELECT nDeviceID
, nDefaultNetworkInterfaceID
, item_id
, item_keya COLLATE Latin1_General_CI_AS
, nDeviceGroupID
, sGroupName COLLATE Latin1_General_CI_AS
, nDefaultNetworkInterfaceID
, sNetworkName COLLATE Latin1_General_CI_AS
FROM WhatsUp_Assyst_replicatie.dbo.device
, WhatsUp_Assyst_replicatie.dbo.item
, WhatsUp_Assyst_replicatie.dbo.DeviceGroup
, WhatsUp_Assyst_replicatie.dbo.NetworkInterface
UNION ALL
SELECT nDeviceID
, nDefaultNetworkInterfaceID
, item_id
, item_keya...
--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)

August 15, 2013 at 5:40 am

#1641740
RE: Put 4 tables in 1 table.. HOW to do that?

Just a heads up, Karmin... posting code as a graphic does absolutely nothing for anyone. We can't copy it and modify it for you.
It would also REALLY be a...
--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)

August 15, 2013 at 5:36 am

#1641738

Viewing 15 posts - 26,191 through 26,205 (of 59,099 total)