Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,681 through 16,695 (of 59,101 total)

RE: Prod vs Dev execution mystery

Yuri55 (10/12/2016)
You mean it can be (let say, potentially) bad query itself? I know it's not the best and we have some ideas how to improve it but even did...
--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 12, 2016 at 9:51 am

#1906161
RE: sql query to display a trailer record at the end in txt file (using batch file)

patilpallavi16 (10/12/2016)
Thanks a lot! It does work.:-)
Thanks for the feedback. The question now is... Did you work out the record length so that it's 300 instead of 302? ...
--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 12, 2016 at 9:48 am

#1906160
RE: database growth

WhiteLotus (10/11/2016)
Hi
I want to monitor the growth of database size in production , so I run a query which tells me the backup size in 1 month ,
Database...
--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, 2016 at 11:51 pm

#1906025
RE: Environment variables set up

Phil Parkin (10/11/2016)
komal145 (10/11/2016)
I think to be more specific, i am deploying the solution from visual studio. the other solution has no issues. only the solution which I am working...
--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, 2016 at 11:46 pm

#1906024
RE: sql query to display a trailer record at the end in txt file (using batch file)

patilpallavi16 (10/10/2016)
USE [St]
GO
/****** Object: StoredProcedure [dbo].[P_tnvin] Script Date: 10/10/2016 13:35:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[P_tnvin]
AS
BEGIN
SET NOCOUNT ON;
Create Table TmpTNVINInfo
(
VINRecord...
--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, 2016 at 11:23 pm

#1906023
RE: Prod vs Dev execution mystery

Yuri55 (10/11/2016)
Have a really strange case when same UPDATE statement (part of SP) runs on Prod sql server for few hours while on Dev one- under minute. Prod sql...
--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, 2016 at 10:03 pm

#1906021
RE: Locking a table while being refreshed

BI_Dev (10/11/2016)
Hi,
Is it possible to block all users from querying a table while it's being refreshed (truncate/insert into) by a maintenance job? I'm not a DBA but would like...
--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, 2016 at 9:55 pm

#1906020
RE: Create Job Server

Deny Christian (10/11/2016)
Hello Experts,
I'm New to this Forums,
Kindly need advice about
Integrity-->backup-->reorganize-->rebuild index-->clean up
I want to make job schedules based on these criteria.
whether to separate or can be made 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)

October 11, 2016 at 9:43 pm

#1906017
RE: SQL Export to CSV Problem

jay-125866 (10/11/2016)
I am using the following code to mail out a CSV file. When total number of characters in a row is more than 250(or so), the text was moved...
--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, 2016 at 9:20 pm

#1906015
RE: How to force column explicitly to string type before we export to excel

Phil Parkin (10/6/2016)
Eric M Russell (10/6/2016)
Jeff Moden (10/5/2016)
komal145 (10/5/2016)
i have check other tables and do lot of stuff to get this point . So , i have to do 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, 2016 at 8:51 pm

#1906014
RE: Bingle is my Senior DBA

andrew gothard (10/11/2016)
pdanes (10/8/2016)
I don't know about for the net in general, but for this forum, maybe Steve could institute some sort of marking for people that know what they...
--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, 2016 at 9:02 am

#1905920
RE: How to Upgrade T-SQL Skills

Talib123 (9/27/2016)
Hi All,
I'm a production DBA and have been for a good while.
I can query, join filters but how do I get my T-sql skills to a developer\Report writer...
--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, 2016 at 8:42 am

#1905913
RE: Are the posted questions getting worse?

Grant Fritchey (10/10/2016)
This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.
No need to pile...
--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, 2016 at 8:32 pm

#1905805
RE: Are the posted questions getting worse?

drew.allen (10/10/2016)
Brandie Tarvin (10/10/2016)
Grant Fritchey (10/10/2016)
This was an... interesting? ... read. Weird location. I've never heard of this person. I think this is their only SQL writing. It's just odd.
No...
--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, 2016 at 8:26 pm

#1905804
RE: How to divide money between two participants

mcfarlandparkway (10/10/2016)
I have two tables one is temporary and another is main dbo employee
In the main table I have added a column called fullamount. Basically this fullamount column is coming...
--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, 2016 at 3:52 pm

#1905792

Viewing 15 posts - 16,681 through 16,695 (of 59,101 total)