Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,276 through 25,290 (of 59,102 total)

RE: Check Data exists or not

kapil_kk (11/30/2013)
can you please tell me how merge doesn't process row by row...
Actually, everything in SQL Server processes "row by row". If you let SQL Server do it, it'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 30, 2013 at 11:13 pm

#1669938
RE: what is the sql server edition for trial download

I can confirm that. If you take a gander at the following URL...
http://technet.microsoft.com/en-us/library/cc645993.aspx
, which is titled "Features Supported by the Editions of SQL Server 2012", you'll find a note...
--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 30, 2013 at 10:09 pm

#1669935
RE: Identify Duplicate Records according to Multiple Criteria

Sy-1148362 (11/30/2013)
Hi There!
I have an Employee table with Columns:
EmpID | FirstName | MiddleName | LastName | SSN | BirthDate | HireDate | City | Zip
Requirement: I have to identify 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 30, 2013 at 9:54 pm

#1669934
RE: updating rows with xml

I guess my question would be, why are you storing this data as XML to begin with? Why aren't you storing it as properly normalized data?
--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 30, 2013 at 9:48 pm

#1669933
RE: How join two tables? Hierarchical table

mesteruh (11/30/2013)
I have two table. Department is hierarchical table.
Department
--- id (int primary key)
--- name (varchar)
--- parent (int)
Users
--- Id
--- name
--- department_id
This query return all data from departments. But i cannot understand...
--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 30, 2013 at 2:43 pm

#1669921
RE: Database restoring,,,,, since 20 hrs

KcV (11/30/2013)
Hi,
i have 25 GB database backup file. I just restored it with a different database name. after starting restoring process it took hardly 20-30 minutes to complete the process...
--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 30, 2013 at 2:32 pm

#1669920
RE: Unlocking stored procedures

rahuldhawan2007 (11/30/2013)
@jeff Moden
Hello Jeff i understand your concern. i'm not trying to hack it. actualy i'm dealing with a project created by a former employee of the company. Now 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)

November 30, 2013 at 11:20 am

#1669917
RE: Unlocking stored procedures

rahuldhawan2007 (11/29/2013)
Hi All
I have a MLM database in which some stored procedures are locked. Could you please guide me how to unlock a lock stored procedure.
Thank you in Advance
Why do...
--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 30, 2013 at 1:11 am

#1669903
RE: Cannot restore database. Cannot get exclusive accesss

Set it to "single user" with "Rollback immediate" then immediately to "multi-user" and then immediately execute the restore command. Of course, these 3 things should be in a script.
--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 30, 2013 at 1:08 am

#1669902
RE: Going over their heads: IT Decisions

I don't think it ironic at all that some consider IT to be conservative. Look at all the crap that has been shoved down our throats that we've had 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)

November 30, 2013 at 1:05 am

#1669901
RE: insert into table execution of a stored procedure

Is your server case sensitive by any chance? Also, what is the compatibility level for the database set 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)

November 30, 2013 at 12:56 am

#1669899
RE: SQL Server - Converting row data to columns

The following article has your answer both by method and with performance in mind.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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 30, 2013 at 12:53 am

#1669898
RE: MSBI career

soumya.halder93 (11/28/2013)
Hello Everyone,
I have 2.11 yrs of experience in SQL Server development and .Net too. Have more interest to Database side and hence learned MSBI(SSIS,SSRS,SSAS,MDX etc.),also know SQL Server DBA...
--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 29, 2013 at 5:25 pm

#1669889
RE: Display data in a Table

I'm no Ninja at XML but I have to say that's some of the most poorly formed XML I've ever seen. Is there any way to get the provider...
--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 29, 2013 at 5:17 pm

#1669888
RE: how to reset SA password

"Basic Authentication"? Do you mean "SQL Server Authentication"?
--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 29, 2013 at 5:12 pm

#1669887

Viewing 15 posts - 25,276 through 25,290 (of 59,102 total)