Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,606 through 25,620 (of 59,099 total)

RE: Exceptionally slow row addition or modification on table associated to indexed view.

Champagne Charly (10/18/2013)
I have an index view (9M rows) based upon[font="Arial Black"] 2 cross joined tables[/font].
The storage of the index is in filegroup and is not partitioned.
No pages aprox =...
--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)

October 18, 2013 at 2:13 pm

#1659856
RE: SQL Server-Table having 40 Billion Records

pawan.khandelwal (10/18/2013)
ok..can you just give me rough estimate how much time SQL to take to fetch 20 million records
What is it that you're doing with those "records"? If you're...
--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)

October 18, 2013 at 8:25 am

#1659735
RE: Takes long to open report

I've found that even the fastest queries are slowed down a whole lot by SSRS. I don't know what they do behind the scenes but I'd fire a Developer...
--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)

October 17, 2013 at 11:05 pm

#1659556
RE: UNION Query help

ScottPletcher (10/17/2013)
Or just:
ORDER BY 1
I often avoid using the column names at all in UNIONed queries, as the names somehow seem to
change a lot 🙂 :
Thank goodness that method...
--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)

October 17, 2013 at 11:02 pm

#1659554
RE: How do you learn new things or keep current with SQL Server?

TWH (10/16/2013)
How do you keep current with SQL Server?
I've decided that it's too big to know everything and, as of 2008, is changing too quickly to keep up with everything...
--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)

October 17, 2013 at 10:58 pm

#1659553
RE: AVG time (hh:mm:ss) in SSRS

mister.magoo (10/17/2013)
...Time Of Day is not something you can average...
Gosh... I have to disagree with that statement that you and Sean made. What if the task is to find...
--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)

October 17, 2013 at 9:38 pm

#1659546
RE: Pass a table variable column value to a SP output variable

Junglee_George (10/17/2013)
If you have understood the problem, please write the code for the solution. I am working for almost a week on this. Thank You.
You've been around this forum long...
--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)

October 17, 2013 at 6:25 pm

#1659534
RE: AVG time (hh:mm:ss) in SSRS

DaveDB (10/17/2013)
Hello all,
I have to say that once again Microsoft has fallen short with their attempt at creating a reporting tool. I have spend the past 2 days trying 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)

October 17, 2013 at 5:48 pm

#1659532
RE: Get the First and Last Day of all the Months based on @ReportDate

sql1411 (10/17/2013)
Is there a way to get the First and Last Day of all the months (including current) based on the @ReportDate for current year and previous year?
Yes.
--===== Create 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)

October 17, 2013 at 5:34 pm

#1659531
RE: Get last day of the month - 1

We can cheat this just a little more if you want...
SELECT DATEADD(dd,-2,DATEADD(mm,DATEDIFF(mm,-1,GETDATE()),0))
--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)

October 17, 2013 at 5:01 pm

#1659529
RE: need hlep to decide the apdesign approach

Abhijit More (10/9/2013)
1. Data Archival requirement-[/b] as per business I need to archive the data mathcing the buinsess rules. for this I have adopted strategy to create the copy 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)

October 16, 2013 at 4:58 pm

#1659096
RE: need hlep to decide the apdesign approach

Abhijit More (10/9/2013)
2. Audit - I have created verticle design having columns - Key ID, Table Name, Column Name, Old Value, New Value, Modified Date. Let's name the table as...
--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)

October 16, 2013 at 4:50 pm

#1659095
RE: Running out of workers

Erland Sommarskog (10/15/2013)
Jeff Moden (10/15/2013)Perhaps I'm using the wrong words but I have to disagree. I don't have many examples but if you have a connection leak, for example,...
--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)

October 16, 2013 at 4:28 pm

#1659093
RE: Disk Space Usage Report

Amit Raut (10/15/2013)
Agreed Jeff! That could be the reason why Microsoft also changed pie-charts to display disk status in 'My Computer' ;-).
Well, do you have any SQL script for 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)

October 16, 2013 at 7:58 am

#1658903
RE: Is TRY-CATCH in SQL still a best practice?

lnardozi 61862 (10/15/2013)
TRY/CATCH statements are used to rollback a transaction if an error occurs in processing. The COMMIT goes at the end of the TRY and the ROLLBACK goes inside...
--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)

October 16, 2013 at 7:49 am

#1658895

Viewing 15 posts - 25,606 through 25,620 (of 59,099 total)