Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,306 through 16,320 (of 59,101 total)

RE: Get Data between two date ranges

Cawie (11/17/2016)
Hello All,
I am new to SQL coding and I need a help.
I need to select data between two dates and this has to be run as stored procedure. When...
--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 17, 2016 at 10:22 pm

#1913283
RE: audit account

To be brutally honest, if you don't know which permissions to request for this audit, then you're probably not qualified to do the audit.
--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 17, 2016 at 10:17 pm

#1913282
RE: use microsoft updates

sqlserverDBA2016 (11/17/2016)
If you go to http://www.sqlcoffee.com/sqlserver2014_0005.htm
And go to Microsoft update u wil know what I'm talking about
You read it. It tells you what it does. Do you suppose...
--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 17, 2016 at 10:14 pm

#1913281
RE: How can automate report from sqlserver to be sent on email everyday.

MMartin1 (11/17/2016)
Jeff Moden (11/16/2016)
tnnelzo (6/20/2013)
Hello!
Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so 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 17, 2016 at 1:46 pm

#1913237
RE: Find the brackets

Here's an example of what I'm talking about with respect to the execution plan. See the attached "Actual Execution Plan" and look at the % of Batch listings for...
--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 17, 2016 at 11:57 am

#1913194
RE: Find the brackets

Stewart "Arturius" Campbell (11/17/2016)
Laurie Dunn (11/17/2016)
This would also work and keep the code simple...
SELECT *
FROM dbo.MyData
WHERE Left(mychar,1)='[';
To further illustrate Luis' point, try this out:
set nocount on;
INSERT #MyData
(mychar)
VALUES
('This 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)

November 17, 2016 at 11:33 am

#1913184
RE: Find the brackets

funbi (11/17/2016)
Luis Cazares (11/17/2016)
funbi (11/17/2016)
The table has 7 rows.
Real world tables don't have 7 rows. A small row count is not a valid excuse for bad code.
It's only bad code...
--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 17, 2016 at 11:27 am

#1913183
RE: delete all tables using sqlcmd

drew.allen (11/17/2016)
I agree with most of what Jeff said, but I would TRUNCATE the tables rather than scripting, dropping, and recreating them.
Drew
Don't forget... If they have FKs on them, TRUNCATE...
--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 17, 2016 at 11:14 am

#1913175
RE: Find the brackets

IMHO, cleaner code if you take the shortcut.
SELECT mychar FROM mydata WHERE mychar 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 16, 2016 at 8:39 pm

#1912947
RE: Disk space report

kevaburg (11/16/2016)
Hi,
exec xp_fixeddrives;
This returns the amount of free space on your local drives. It is a good place to start....
Regards,
Kev
It's really not. It only shows free space. ...
--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 16, 2016 at 7:47 pm

#1912945
RE: How can automate report from sqlserver to be sent on email everyday.

tnnelzo (6/20/2013)
Hello!
Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so that the email 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 16, 2016 at 7:41 pm

#1912944
RE: delete all tables using sqlcmd

whitesql (11/16/2016)
* I need to delete all rows of all tables.
It would be easier on you and the system to create the scripts for all the tables, drop the tables,...
--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 16, 2016 at 7:30 pm

#1912943
RE: Stupid question? How to exclude 'SA' using sp_who

Why on Earth do you need to run such a thing once per minute?
--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 16, 2016 at 9:33 am

#1912841
RE: Held Hostage by the Database

To be honest, I find that such automation is frequently much more complex than certain manual methods and frequently does little to prevent people from overwriting each other's changes...
--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 16, 2016 at 8:14 am

#1912809
RE: Help needed in time conversion

If the input string is limited to less than 24 hours, the following makes life pretty easy and will also produce an error if someone entered improper information that result...
--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 16, 2016 at 8:02 am

#1912804

Viewing 15 posts - 16,306 through 16,320 (of 59,101 total)