Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,826 through 21,840 (of 59,072 total)

RE: Describe & v$views in SQL Server

halmuslim12 (1/19/2015)
Dears,
In oracle DB from command line to describe the table columns / definition you can use : describe "Table Name " what...
--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)

January 19, 2015 at 12:52 am

#1771040
RE: Are the posted questions getting worse?

GilaMonster (1/15/2015)
Sean Lange (1/15/2015)
I am having a discussion with somebody who swears that using
EXISTS(select 1
is way faster than just select *. I know Gail has an article on her...
--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)

January 18, 2015 at 5:32 pm

#1771016
RE: Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

dwain.c (1/18/2015)
The thing I still haven't figured out is why I couldn't find anything on this topic in my searches. It seemed so obvious when I hit upon it,...
--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)

January 18, 2015 at 5:26 pm

#1771015
RE: Insert Statement with IF Statement

Meatloaf (1/18/2015)
Thanks guys! I have it working in SQL. However, when I try to run it in my .Net app, I get a message saying "Error: Must declare...
--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)

January 18, 2015 at 3:57 pm

#1771010
RE: Are the posted questions getting worse?

Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you...
--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)

January 18, 2015 at 3:42 pm

#1771009
RE: temp DB is full

Any long running transaction that caused the explosion in TempDB has already been killed by the system error produced when TempDB ran out of space. The chores now 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)

January 18, 2015 at 12:40 pm

#1771003
RE: display month wise data in sql server

asranantha (1/18/2015)
Hi Friends I have small doubt in sql server please tell me how to resolve this in sql server
Table data like below
id |month|stat|count
1 |1|admit|7
2 |8|admit|47
1 |7|admit|28
2...
--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)

January 18, 2015 at 12:34 pm

#1771001
RE: Insert Statement with IF Statement

Meatloaf (1/18/2015)
Is it possible to have an Insert Statement with an IF?
For example I want to check the value of a field upon insert. If the value is ''...
--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)

January 18, 2015 at 12:29 pm

#1771000
RE: Please explain what this Trigger query does

P.S. I almost forgot... because Item #6 causes only one row to be inserted into the audit table during UPDATEs, it doubles the performance of UPDATEs. Because Item...
--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)

January 18, 2015 at 12:20 pm

#1770999
RE: Please explain what this Trigger query does

lawlietdba (1/17/2015)
Hi Jeff,
Thanks verymuch for your suggestion. As you said I found the separate triggers for Update as well as Delete . Please explain what can be done to improve...
--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)

January 18, 2015 at 11:40 am

#1770998
RE: Help With Trying to Import File Names into a Table

@Lemptster,
Outstanding! Thank you for the time you took on that. I especially appreciate the methods you talked about for the promotion of packages and projects.
Shifting to the subject...
--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)

January 17, 2015 at 5:56 pm

#1770970
RE: Where is the test?

gabgo (1/17/2015)
No, there is nothing at that URL...
Considering the link on that post, reported as SPAM.
--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)

January 17, 2015 at 11:46 am

#1770964
RE: what else can you search for instead of col1 = '' or col1 = ' ' or col1 is null?

TheSQLGuru (1/16/2015)
Butt, the paperwork is simple, although it can smear your reputation and cause quit a stink.
Jeff, that is SOOO over the top!! 😛
Heh... yeah, sorry. I really bottomed...
--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)

January 17, 2015 at 11:33 am

#1770963
RE: Please explain what this Trigger query does

Eirikur correctly described what the code in the trigger does. I'll tell you that the trigger uses older methods, can be improved a bit performance-wise, has unnecessary error handling,...
--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)

January 17, 2015 at 11:19 am

#1770962
RE: Help With Trying to Import File Names into a Table

Eirikur Eiriksson (1/17/2015)
Jeff Moden (1/17/2015)
To help wet my appetite for reading that stairway further, would someone please just tell me how to load the previously identified packages so that 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)

January 17, 2015 at 11:01 am

#1770955

Viewing 15 posts - 21,826 through 21,840 (of 59,072 total)