Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,441 through 16,455 (of 59,101 total)

RE: Delete files that are older than 7 days

Deny Christian (11/1/2016)
else,
i used this syntax
DECLARE @CMD sysname
--create .bat:
/*.bat:
@echo off
forfiles /p "d:\backup\bck_denyc\combine" /m *.bak /c "cmd /c del /Q @file" /d -30 --to delete 30 days back
@echo off
*/
--execute 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)

November 2, 2016 at 7:55 am

#1910100
RE: Include the first zero when converting time from datime into INT

hoseam (11/2/2016)
I have
declare @t datetime = '2016-11-02 07:22:26.320'
SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, @t, 108), ':', '') AS INT), 6)
which gives me INT value of 72226, and I want it to include 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)

November 2, 2016 at 7:15 am

#1910088
RE: Speeding Up Delete's on Large Databases

Wow... That's just silly how well that works! And I've tried a couple of different methods to beat it and haven't been able to even in the SIMPLE Recovery...
--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)

November 1, 2016 at 8:55 pm

#1910032
RE: Maximum number of versions per project in SSIS Catalog Properties

To be honest, this sounds like an interview question. Try the following search and see for yourself.
[font="Arial Black"]http://bfy.tw/8Vtu[/font]
--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)

November 1, 2016 at 5:28 pm

#1910023
RE: Risks of Updating to another edition

luismarinaray (11/1/2016)
Hi Friends,
According this documentation,
https://msdn.microsoft.com/es-es/library/ms143393(v=sql.105).aspx
Upgrade path from SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard, is not a
valid path, I have to update to SQL Server 2008 R2...
--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)

November 1, 2016 at 3:58 pm

#1910018
RE: Query to Dynamically Sum Sales Amounts By Month, Quarter, or Year

ptownbro (11/1/2016)
Thanks guys. I learned a lot from reading Jeff's articles. Interestingly I had already developed Sort path method (which I called a Tree Path) as well as incorporated CTE's...
--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)

November 1, 2016 at 2:59 pm

#1910007
RE: Show data upto 2 decimal places but with exact values

drew.allen (11/1/2016)
snowprincess42073 (10/31/2016)
Hi all,
I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should...
--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)

November 1, 2016 at 2:56 pm

#1910005
RE: Show data upto 2 decimal places but with exact values

snowprincess42073 (10/31/2016)
Hi all,
I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should 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)

November 1, 2016 at 1:46 pm

#1909996
RE: SQL help - how to write a query with reference to its own results

sanda.jan00 (11/1/2016)
drew.allen (10/31/2016)
sanda.jan00 (10/29/2016)
Thanks a lot from both of you!!!
Now, consider the adjusted table provided by you, could you pls give me some advice how to write my query?? 🙂
You...
--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)

November 1, 2016 at 1:34 pm

#1909993
RE: Speeding Up Delete's on Large Databases

ChrisM@Work (11/1/2016)
So we decided to try cache priming - getting the required data into cache with a low-cost read before processing it. A single loop of the code we ran...
--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)

November 1, 2016 at 8:29 am

#1909884
RE: SQL SERVER 2014 Snapshot replication

I don't use SQL Server replication so I can't answer your question but this should serve as another "bump" to your question.
--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 31, 2016 at 9:09 pm

#1909779
RE: What random trash is in your drawer?

Fingers from developers that don't get it yet. 😛
Old AARP cards.
--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 31, 2016 at 9:07 pm

#1909778
RE: insert value comma/ dot issue

kj700098 39683 (10/31/2016)
thanks but I have tried default language = norwegian and no help.
The issue is that that the transact sql see four columns here
VALUES (1, '1 Value', 18,2)...
--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 31, 2016 at 8:05 pm

#1909775
RE: SENDING DAILY EMAIL ATTACHMENT WITH SQL QUERY TO GIVEN USERS.

philand3 (10/23/2016)
Dear All,
i would like to send out following query to all email users daily basis,can anyone guide me the direction,
it can be from SQL or external tool,ETC.
SELECT ...
--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 31, 2016 at 7:49 pm

#1909774
RE: insert value comma/ dot issue

I'm not totally sure but I believe you'll have to change the language setting. You'd do that with the follow syntax example from Books Online. Make the appropriate...
--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 31, 2016 at 7:03 pm

#1909772

Viewing 15 posts - 16,441 through 16,455 (of 59,101 total)