Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,426 through 25,440 (of 59,099 total)

RE: T-SQL Performance tuning on Aggregates

d_uvarajan (11/11/2013)
I use Numeric(10,0) for all Ids in the temeperary tables because the same was defined earlier in their corresponding original tables.
Ya just gotta love tables developed by tools (human...
--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 11, 2013 at 3:02 pm

#1665596
RE: Drop and Create table or Trunc table

Honny (11/11/2013)
As you mentioned there is no Foreign Keys so truncate and load is better.
1. If you drop the table again you have to create the table and 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)

November 11, 2013 at 2:40 pm

#1665593
RE: Slow performance

I believe that I'd change the following code to a NOT EXISTS instead of doing a count.
And 0 = (Select Count(*) From DataQueue Where ImageId = Q.ImageId And FieldId =...
--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 11, 2013 at 2:29 pm

#1665592
RE: Proc with input paramaters does not compile

Lynn Pettis (11/11/2013)
Just a suggestion based on my own philosophy, regardless of collation used (case sensitive or case insensitive) you should write your code as if it is always case...
--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 11, 2013 at 2:26 pm

#1665591
RE: Disk space gets full and cluster goes offline

Ryan007 (11/11/2013)
Thanks Perry
[font="Arial Black"]But disk might get full due to huge transactions[/font]. So to prevent this, is there anything that can be done so that LUN does not go offline...
--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 11, 2013 at 2:16 pm

#1665585
RE: Split function in sql

Bhuvnesh (11/11/2013)
create function dbo.SplitString
(
@str nvarchar(max),
@separator char(1)
)
returns table
AS
return (
with tokens(p, a, b) AS (
select
...
--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 11, 2013 at 2:13 pm

#1665583
RE: use cte instesd of while and temp table

Lynn Pettis (11/11/2013)
If I read your code correctly, this may work:
INSERT INTO FarzinIntro
SELECT
r.Role_ID,
r.User_ID,
dt1.n,
GETDATE()
FROM
...
--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 11, 2013 at 2:02 pm

#1665580
RE: Index tuning

namdinh4 (11/11/2013)
Hey all,
I am doing an evaluation against all indices on my database, and I have a question regarding index maintenance. I could not find the answer anywhere else, so...
--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 11, 2013 at 1:59 pm

#1665579
RE: There is a prefered age for developers and administrator the recruiters in companies preferred it?

MohamedDBA (11/11/2013)
I'm in 30 years old now and try to find a job in SQL Server Administration and Development but I'm afraid of age discrimination , and this makes me...
--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 11, 2013 at 1:55 pm

#1665577
RE: Ideas for stopping customers meddling directly in the tables?

James_UK_Dev (11/11/2013)
We have some issues with customers meddling directly in the tables for our application.
Has anyone any ideas for monitoring or preventing this?
I'm not talking about for malicious fraud reasons,...
--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 11, 2013 at 9:44 am

#1665521
RE: What Do You Want to Learn?

arnipetursson (11/11/2013)
Jeff Moden (11/9/2013)
arnipetursson (11/8/2013)
A talk about how to determine the right tool for the job.
Very cool. I'll start with a bit of a play on words. "Just...
--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 11, 2013 at 9:42 am

#1665520
RE: Subqueries

dwain.c (11/10/2013)
Any time I see something like "Coding required as Subquery NOT as Join" it tells me for sure this is homework.
You'll find that few on this forum are willing...
--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 10, 2013 at 10:05 pm

#1665363
RE: Jr. Business Intelligence Analyst (Mid-Michigan)

Luis Cazares (11/7/2013)
Do you provide sponsorship for mexicans?
If they don't, they should make an exception for you. You're one of the best out there.
--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 10, 2013 at 10:02 pm

#1665362
RE: database options not being copied from model db

curious_sqldba (11/10/2013)
I have made some db level changes on model db and the intent was to have those settings copied over on every db created on that instance. Now 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)

November 10, 2013 at 12:23 pm

#1665349
RE: Most frequent used stored procedures without access to system tables

bhutchin (11/10/2013)
Ron - thank you for replying so soon. However, because I do not have access to the system tables the query does not work for me. Here is 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 10, 2013 at 12:19 pm

#1665348

Viewing 15 posts - 25,426 through 25,440 (of 59,099 total)