Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,296 through 23,310 (of 59,102 total)

RE: Table Designing

Lempster (7/2/2014)
Bill Talada (7/2/2014)
Set your own standards and stick to them....
I agree with that! Everything else (trying to promote your standards over others) just opens up a can of worms...
--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 2, 2014 at 10:53 am

#1726577
RE: Need help with employee hierrarchy

sunitkrishna (7/2/2014)
Hi,
I need help with the following query:
----------------------------------------------------------------------------------------------
declare @LoginId nvarchar(20)
set @LoginId='A-1519'
declare @LoginName nvarchar(100)
set @LoginName=(select [FirstName] + ISNULL(''+[MiddleName],'') + ISNULL(''+[LastName],'')
from [dbo].[Employee] where EmpId=@LoginId)
;WITH EmployeeTree(EmpId,FullName,DesignationName,ReportingMgr,LoginMgr)--,TreeLevel)
AS (
SELECT EmpId,[FirstName] +...
--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 2, 2014 at 10:41 am

#1726572
RE: How to repair backup of .mdf file database?

jasonkabe22 (7/1/2014)
Data from corrupt mdf file can be recovered by following methods:
Repair MDF file with DBCC CHECKDB: Microsoft offers a command that is known as DBCC CHECKDB, when you run...
--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 1, 2014 at 11:00 pm

#1726376
RE: Data Dictionary Table in Staging Database

P Jones (7/1/2014)
Yes there are uses for these files. It logs what has been delivered and lets others see what fields are available.
It also gives you a way 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)

July 1, 2014 at 10:53 pm

#1726374
RE: Stored Procedure Performance

LSAdvantage (7/1/2014)
I have had to optimize several poor performing stored procedures and queries at my company and the solution in every case is often different. Here are a few...
--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 1, 2014 at 10:41 pm

#1726373
RE: BCP

Admingod (7/1/2014)
Do you think it cannot be done with BCP?
Thanks
I absolutely think BCP will do it. That's why I recommend using the -CRAW command line switch for BCP. 😀
--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 1, 2014 at 6:29 pm

#1726360
RE: Who TOOK the backup?

New Born DBA (7/1/2014)
The situation is that someone took the backup of the DB (which nobody should), which made the available space on the drive very low. Now nobody knows...
--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 1, 2014 at 11:10 am

#1726294
RE: Good practice to separate tables with static data?

I'll also suggest putting the tables in a different file/filegroup and, possibly, making the file group READ only depending on whether or not the tables are trully static. 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)

July 1, 2014 at 11:09 am

#1726292
RE: Query Runs on Production and Not on Development SQL Server

As a bit of a sidebar, I've seen dozens of such posts concerning 2012 and it's not making me real comfortable about 2012.
Rumor has it (I've not done a deep...
--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 1, 2014 at 9:16 am

#1726232
RE: And then today this happened...

sqldriver (7/1/2014)
Tough crowd. I thought the NOLOCK on an update was amusing.
BWAAA-HAAA!!! Ok... I get it. It wasn't a question... it was a statement about something that 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)

July 1, 2014 at 9:13 am

#1726230
RE: Best way to prepare for interview?

The best way to prepare for an interview is to apply for jobs that aren't too far out of your area of expertise and to remember what people were looking...
--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 1, 2014 at 9:06 am

#1726229
RE: Extract only numbers from a string

Jeff Moden (7/1/2014)
LoosinMaMind (6/30/2014)
Hi, I have no the following.
can someone help me tweak it so the i get both sets of numbers rather than just the first, these then...
--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 1, 2014 at 8:43 am

#1726225
RE: Can frequent shrink files cause DB corruption

Nadrek (7/1/2014)
Jeff Moden (6/30/2014)
Heh... yep... they used to say that about online index rebuilds, as well. I do agree that shrinks are generally a bad idea, though.
...make sure 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 1, 2014 at 7:42 am

#1726192
RE: How to take the backup of 700gb with less time

"Divide and Conquer".
The question is, how to "divide". "It Depends" on the structure of the database. I would move all the very large, high usage tables to 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 1, 2014 at 12:19 am

#1726055
RE: point all transactions and activity to new database file so old one ceases to grow

I guess I wouldn't try such a thing. I believe that if you simply add another file to the file group, it will use that new file until both...
--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 1, 2014 at 12:12 am

#1726053

Viewing 15 posts - 23,296 through 23,310 (of 59,102 total)