Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,001 through 18,015 (of 59,102 total)

RE: Restore help needed for 1.5 TB database.

EdVassie (4/1/2016)
This means your filegroup backups can run in parallel. When you do a restore each filegroup can be restored in parallel, with greater parallelism given from the striping.
If they're...
--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:27 pm

#1869280
RE: How do I Avoid Deadlocks?

Seggerman-675349 (4/1/2016)
on behalf of my client - thanks all
the process already makes most of its updates to a staging table - and only at the very end copies the data...
--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:17 pm

#1869279
RE: BCP to insert data from text file to table

PJ_SQL (4/1/2016)
I have this file as below
'A',
'B',
'C',
I am using this bulk insert below:
BULK INSERT test..A FROM 'c:\test.txt'
WITH (
DATAFILETYPE='char',
...
--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:09 pm

#1869278
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

Viewing 15 posts - 18,001 through 18,015 (of 59,102 total)