Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,041 through 26,055 (of 59,099 total)

RE: View Contents of a Log Backup

tom 28327 (8/28/2013)
I noticed in one of my overnight scheduled log backups that it was huge 500MB for 800MB database. Usually my log backups are relatively small 30MB. I would...
--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 29, 2013 at 10:32 pm

#1646229
RE: Would like to add data in table when sql m/c starts or shutdown

harsimranjeetsinghwasson (8/29/2013)
I would like to add data like time in a table in sqlserver when sqlserver machine is started or shutdown.
This information is recorded in the SQL Server logs and...
--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 29, 2013 at 10:28 pm

#1646228
RE: Create a stored procedure on multiple databases

Guras (8/29/2013)
How can I create sps on multiple database?
This will sound like a silly question but I have to make absolutely sure, first... Will the stored procedure 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)

August 29, 2013 at 10:17 pm

#1646227
RE: Close existing connections

I do it by script like Erland did except I go back to Multi-User immediately after the set to Single-User. Web servers won't be able to respond fast enough...
--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 29, 2013 at 10:13 pm

#1646226
RE: How to find orders that contain the same product

In that case, why not just return the value in the XML format that they want? It's pretty easy to do. In fact, the solution that Sean posted...
--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 29, 2013 at 10:07 pm

#1646225
RE: Wrong datatype for SP?

SrcName (8/29/2013)
Hi Junglee_George,
make your query dynamic.
declare @sqlText varchar(max)
set @sqlText = 'SELECT
MC.MaterialItemContainerCode,
MC.ReceptionDate,
C.clientName ,
MI.materialItemName
FROM
MaterialsItemsContainers MC
INNER JOIN MaterialsItems MI WITH(NOLOCK)
ON (MC.materialItemIncId = MI.materialItemIncId AND MC.materialItemSqlId = MI.materialItemSqlId AND MI.isDeleted=0x0)
INNER JOIN Clients 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)

August 29, 2013 at 9:46 pm

#1646222
RE: Wrong datatype for SP?

Junglee_George (8/28/2013)
What should this nvarchar(MAX) be changed to accommodate the comma seprated values?
How many comma separated values can you 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 29, 2013 at 9:45 pm

#1646221
RE: Best Way to Synchronize Database

We use SAN replication over a dedicated line. I'm not sure how it works but the folks in NetOps have it absolutely screaming.
--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 29, 2013 at 9:40 pm

#1646220
RE: Can you please help me??

Sigerson (8/29/2013)
Doing all of that within one SQL statement or a With block is beyond me,...
It's beyond me, too. But then again, I wouldn't even try 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)

August 29, 2013 at 9:34 pm

#1646218
RE: Improving the performance of a Big table

HanShi (8/29/2013)
Koen Verbeeck (8/29/2013)
And how can you improve a query? By updating statistics, minimize logging, creating indexes, compress the data, partition the table, ... 🙂 😉
You are absolutely right, but...
--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 29, 2013 at 9:26 pm

#1646216
RE: time range dimention based on a number

No. You could add a computed column for this. I recommend it be a persisted computed column to make it faster.
--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 29, 2013 at 9:21 pm

#1646214
RE: Job Fails 1/2 Way Through When Scheduled, Completes Manually

I'd be interested in knowing the answer to this because I have a similar problem with a backup proc. I specifically programmed it to catch an error in 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 29, 2013 at 9:17 pm

#1646212
RE: how to alter the existing id values to idetity(1,1)

ScottPletcher (8/29/2013)
ALTER TABLE dbo.tblemployee
ADD ident int IDENTITY(1, 1) NOT NULL
Edit: Added "NOT NULL"
The NOT NULL is great visual confirmation that the column will be NOT NULL, but the IDENTITY property...
--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 29, 2013 at 8:55 pm

#1646211
RE: Commit

I'd like to ephasize what Erland wrote. There will always be the rare exception but get into the habit of using SET XACT_ABORT ON even if you don't use...
--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 29, 2013 at 8:35 pm

#1646210
RE: sp_getrecords to get all records from a table

saravanakumar.G (8/28/2013)
any help on this??? 🙁
Yes. If you insist on creating this proc, I recommend that you include a TOP 100 or TOP 1000 in the proc so 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)

August 29, 2013 at 8:27 pm

#1646209

Viewing 15 posts - 26,041 through 26,055 (of 59,099 total)