Jeff Moden

Forum Replies Created

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

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
RE: Check Data exists or not

Be very careful if you decide to use MERGE. There are several CONNECT items that are open about it and, like anything else, if you don't obey some fairly...
--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:08 pm

#1669885
RE: Filter using dates

RTaylor2208 (11/29/2013)
WHERE b.PropertyCode='PCH'
AND b.CreatedON BETWEEN '2013-11-29' AND '2013-11-30'
This will give you the time range '2013-11-29 00:00:00.000' till '2013-11-29-29 23:59:59.999' encompasing the whole day.
Another option is
WHERE b.PropertyCode='PCH'
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)

November 29, 2013 at 5:05 pm

#1669884
RE: Core T-SQL

Gary Varga (11/27/2013)
I am in shock.
With all that has been posted here I am either a SQL Server god (because the majority are rubbish - thanks for the ego boost...
--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 4:53 pm

#1669883

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