Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,971 through 17,985 (of 59,069 total)

RE: By date

girl_bj (3/29/2016)
It will be continuous. I am just testing for 1 month on how it works. The weekly data will be send as an output file.
Is there any way 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)

April 1, 2016 at 8:03 am

#1869159
RE: Count patterns of behaviour

pbo71465 (4/1/2016)
Could you help me with this Bitcode method?
Start here: https://msdn.microsoft.com/en-us/library/ms176122.aspx
--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)

April 1, 2016 at 8:02 am

#1869156
RE: How To Format Phone Number

cad.delworth (4/1/2016)
The Dixie Flatline (4/17/2009)
if you just stored phone numbers as integers, you would trim fat out of the row size as well.
… and if you stored UK phone numbers...
--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)

April 1, 2016 at 7:59 am

#1869155
RE: Help with Dates

SQL_Kills (4/1/2016)
Hi,
I need help with the below sql, basically for whatever date that is passed into the variable @dt I want the variables @dtFrom and @dtTo to be calculated 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)

April 1, 2016 at 7:43 am

#1869153
RE: Restore help needed for 1.5 TB database.

I'm thinking that the 1200 files could be due to the partitioning of 1 or more large tables. It's not unheard of for folks to partition by week 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)

April 1, 2016 at 7:38 am

#1869151
RE: drop temp table owned in another session

snomadj (4/1/2016)
Thanks all. I get the gist. Didn't know if there was a:
DROP TABLE [sessionID, databaseName, #tableName] command I didn't know about.
Appreciate your time to respond. ...
--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)

April 1, 2016 at 7:34 am

#1869148
RE: Processing strings.

Sachin Nandanwar (3/31/2016)
Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It can be...
--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)

April 1, 2016 at 12:56 am

#1869060
RE: SnowCrash for SQL Server

From the article:
there's a project underway to bring more virtual reality to our everyday world
Don't need more of that. I already have managers and users whose perception of...
--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)

April 1, 2016 at 12:50 am

#1869059
RE: Restore help needed for 1.5 TB database.

Chitown (3/31/2016)
I will personally kick his/her butt .
BWAAA_HAAAA-HAAAA-HAAAA!!! Finally! A true kindred spirit! 😛 You made my day!
--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 31, 2016 at 6:45 pm

#1869038
RE: Is there a way to restrict backups or sql agent jobs with low priority

Not sure if you've seen the following...
https://msdn.microsoft.com/en-us/library/cc280384(v=sql.120).aspx
https://www.mssqltips.com/sqlservertip/3370/use-sql-server-2014-resource-governor-to-throttle-processes-for-io-usage/
Disclaimer... I'm still stuck in 2005 and haven't actually tried either of these methods, yet.
--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 31, 2016 at 6:40 pm

#1869037
RE: Convert a string with an array of variables?

Ed Wagner (3/31/2016)
Between this and Sergiy's post, now I can't wait to start playing. 😉
Sergiy's method is the same method as "Section 7" of the outline we worked on for...
--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 31, 2016 at 6:28 pm

#1869036
RE: Convert a string with an array of variables?

Sergiy (3/31/2016)
Alan.B (3/31/2016)
How would this be applied against a column in a table?
It depends.
Simplest way would be to add a new column, create a scalar function out of 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 31, 2016 at 6:27 pm

#1869035
RE: mysterious slowdown every 4 minutes

andrea.dimaio (3/31/2016)
Hi
I' ve a database used to a gaming application. 99% of procedure called by the application are 2 stored procedure called 'new_transaction' and 'upd_trandaction'. Those stored are called usually...
--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 31, 2016 at 8:12 am

#1868857
RE: Is PowerShell Intimidating?

Manic Star (3/31/2016)
I just wrote a script in PS that iterates through my databases on server X and gives me a lovely csv file of all the permissions on all...
--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 31, 2016 at 8:03 am

#1868854
RE: Is PowerShell Intimidating?

Manic Star (3/30/2016)
Powershell is awesome! Then i'm a former developer, so it was like the power of .net without the annoying user interface layer to program. It just does what...
--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 30, 2016 at 12:24 pm

#1868701

Viewing 15 posts - 17,971 through 17,985 (of 59,069 total)