Jeff Moden

Forum Replies Created

Viewing 15 posts - 28,111 through 28,125 (of 59,101 total)

RE: DTEXEC Failing with Xp_cmshell but runs in cmd line

opc.three (11/22/2012)
The ideal situation would be to begin refactoring your way out of using xp_cmdshell so you can eventually disable it. You could start leveraging the SSISDB available as part...
--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 22, 2012 at 7:45 pm

#1561733
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

dave-L (11/22/2012)
Hi Jeff. That's my whole question really. Is there a good way to fix this and is it worth trying to fix.
True using a UDF to generate the UUIDs...
--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 22, 2012 at 7:37 pm

#1561732
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

CELKO (11/22/2012)
Most often non-RDBMS people use their generated physical locator as the cluster because this is how a magnetic tape or disk access modle of data would have done it.
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 22, 2012 at 7:31 pm

#1561731
RE: Weekly data converted to months

scottsanpedro (11/22/2012)
Hi Jeff. No I currently do not have that.
Are you suggesting I need to do this to progress this as a solution?
I'll be back on this tomorrow so will...
--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 22, 2012 at 7:21 pm

#1561730
RE: Weekly data converted to months

scottsanpedro (11/22/2012)
Hi all. Hope you can help. I have data that is structured by week format.
Year Week Total
2012 49...
--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 22, 2012 at 1:35 pm

#1561709
RE: The Small Print

Proof positive that the Cloud can be "Smoke and Mirrors".
Caveat Emptor!
--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 21, 2012 at 11:59 pm

#1561499
RE: Deadlock that I cannot figure out.

What do the 2 stored procedures listed in the deadlock graph look like?
--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 21, 2012 at 11:53 pm

#1561497
RE: directional based search

"It Depends". 😉
Which rows would you want to come back if the user just asked for "Small Bed"? All but 2 and 4?
--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 21, 2012 at 11:45 pm

#1561495
RE: Parameterized dynamic SQL

dwain.c (11/21/2012)
Jeff Moden (11/21/2012)
dwain.c (11/21/2012)
Would this work?
DECLARE @DB VARCHAR(100) = 'MyDB'
SELECT *
FROM @DB.sys.check_constraints
If not, why would it work in dynamic SQL?
Obviously, you've found an approach that does work though.
I haven't...
--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 21, 2012 at 11:31 pm

#1561491
RE: Parameterized dynamic SQL

D.Post (11/21/2012)
Is this correct or is there another way to do this?
Something to do with SQL Injection? (No fear of)
No. No way to stipulate the database name 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)

November 21, 2012 at 11:27 pm

#1561489
RE: Parameterized dynamic SQL

dwain.c (11/21/2012)
Would this work?
DECLARE @DB VARCHAR(100) = 'MyDB'
SELECT *
FROM @DB.sys.check_constraints
If not, why would it work in dynamic SQL?
Obviously, you've found an approach that does work though.
I haven't fired up 2k12...
--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 21, 2012 at 11:14 pm

#1561486
RE: Default fillfactor kept by SQL Server when it is rebuilding the indexes.

You bet. Thank you for the feedback.
--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 21, 2012 at 11:05 pm

#1561484
RE: Why does my log show two backup events for the same database?

I had a similar problem. It turned out to be a job running that would switch the database to SIMPLE to load some tables in the hopes of getting...
--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 21, 2012 at 11:03 pm

#1561482
RE: Delete Orphaned Constraints

AndrewSQLDBA (11/21/2012)
We do not drop objects.
Why not? If an object needs to be dropped, what's wrong with dropping it? And, during development, I conditionally drop objects and rebuild...
--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 21, 2012 at 11:00 pm

#1561480
RE: Changing Column Data type

sanket kokane (11/21/2012)
First ,thanks for the nice question ,I always used to thought it takes alter table command at the back end .
I have attached my results with client statistics...
--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 21, 2012 at 10:50 pm

#1561476

Viewing 15 posts - 28,111 through 28,125 (of 59,101 total)