Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,131 through 23,145 (of 59,099 total)

RE: disk space 90% full...

pdanes (7/21/2014)
samking (7/21/2014)
If the disk contains only data files...than what action we have to take......
If the disk contains only data files and is 90% full, then you will need 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)

July 21, 2014 at 11:30 pm

#1731313
RE: 15 minute interval report between two dates with total for each interval

.Netter (7/21/2014)
I can upload anything to the internet within working hours im afraid really strict rules here 🙁
I assume you mean "I can't upload anything...". Understood, appreciated, and I...
--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)

July 21, 2014 at 11:25 pm

#1731312
RE: disk space 90% full...

samking (7/21/2014)
If the disk contains only data files...than what action we have to take......
But it doesn't, does it. Notice that's not a question because you previously said it doesn't.
If...
--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)

July 21, 2014 at 11:16 pm

#1731310
RE: disk space 90% full...

mohan.bndr (6/21/2012)
...it is having data files , log files and backups also. So in this case what step should i take to get more space in that disk..
Step one 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)

July 21, 2014 at 11:12 pm

#1731308
RE: 1 Quick question for all the DBA's

New Born DBA (7/21/2014)
Jeff Moden (7/21/2014)Read about what? If it's not about SQL Server, T-SQL, or setting up one of the "silly" experiments you were talking about, etc, etc,...
--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)

July 21, 2014 at 11:09 pm

#1731307
RE: Backing up a DB with log shipping turned on

Perry Whittle (7/21/2014)
Steve Jones - SSC Editor (7/21/2014)
GilaMonster (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups do not break the log...
--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)

July 21, 2014 at 10:51 pm

#1731306
RE: Need Help parsing through the XML

Evil Kraig F (7/21/2014)
mister.magoo (7/21/2014)
So is that right? You have a stored procedure that produces XML from data stored in tables and now you want to shred that XML to...
--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)

July 21, 2014 at 9:28 pm

#1731297
RE: Need Help parsing through the XML

koolme_85 (7/21/2014)
i need to copy this storedproc results into temp table
and then convert the above xml into table
Ok... I realize that some folks in this thread have come...
--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)

July 21, 2014 at 9:25 pm

#1731295
RE: Need Help parsing through the XML

Sarah Wagner (7/21/2014)
Eirikur Eiriksson (7/21/2014)
Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods,...
--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)

July 21, 2014 at 9:22 pm

#1731294
RE: 15 minute interval report between two dates with total for each interval

.Netter (7/21/2014)
Hello,
I’m trying to create a report which will give me a break down of how many unique vehicles have been seen between two dates via a 15 minute interval...
--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)

July 21, 2014 at 9:16 pm

#1731293
RE: Generate script to restore log backups

SQLRNNR (7/21/2014)
Jeff Moden (7/21/2014)
Getting back to the original problem, if you had 2000 log files over the week and did, say, daily DIFs, would you actually delete the log files...
--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)

July 21, 2014 at 9:12 pm

#1731292
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
Jeff Moden (7/21/2014)
halifaxdal (7/21/2014)
as I suspect if the EOF was recognized by bulk insert, I compare the two data files (the larger file costs me long time to load...
--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)

July 21, 2014 at 9:07 pm

#1731291
RE: 1 Quick question for all the DBA's

New Born DBA (7/21/2014)
... there are days I just sit on my desk and pretty much read.
Read about what? If it's not about SQL Server, T-SQL, or setting up...
--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)

July 21, 2014 at 8:44 pm

#1731290
RE: How to run a SQL job using different account.

Mac1986 (7/21/2014)
I created a job with a step which has OperatingSystem(CMDEXEC) and run as DOMAIN\MYACCOUNT.
SQLCMD -q "SQLOPSDB.DBO.sp_now"
But now the job is not finishing as the above command does...
--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)

July 21, 2014 at 8:12 pm

#1731288
RE: Index grows really fast!

murnilim9 (7/21/2014)
twin.devil (7/21/2014)
If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase your...
--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)

July 21, 2014 at 8:08 pm

#1731286

Viewing 15 posts - 23,131 through 23,145 (of 59,099 total)