Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,531 through 19,545 (of 59,072 total)

RE: Executing query/SPs thru Command line

Tac11 (9/23/2015)
Hi experts,
How do I execute below scripts using CMD:
Please Note: SQL server 2008r2, default instance with window Authentication.
1. Select * from Adventurewoks2008.Person.Person where Id = 5
2. Exec usp_getemployee...
--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)

September 23, 2015 at 5:53 pm

#1828985
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

Just to ask the question again...
Jeff Moden (9/22/2015)
@erichansen1836
Just a quick question and apologies for not following/reading all of the posts that have occurred since the last time I dropped...
--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)

September 23, 2015 at 5:44 pm

#1828982
RE: Disabling Indexes for Load Performance

Don't drop or disable the clustered index.
As someone already said, if you disable the clustered index, none of the data will be available.
If you drop the clustered index,...
--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)

September 23, 2015 at 5:39 pm

#1828981
RE: Import CSV. Multiple Rows. Split order when items total 720g

chris-1111548 (9/23/2015)
SSIS 2008
Hi there,
we import orders for our clients from .csv text files that they provide us each day.
For us to achieve the maximum discount from Royal Mail our items...
--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)

September 23, 2015 at 4:54 pm

#1828978
RE: Calculating running totals for partitions of data

kdejan87,
Does the table have any kind of column(s) that would indicate the correct order of the transactions?
--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)

September 23, 2015 at 4:40 pm

#1828975
RE: Calculating running totals for partitions of data

kdejan87 (9/23/2015)
View fourth answer and tell me your opinion
[font="Arial Black"]ALL [/font]the answers are incorrect because there is no column that enforces the order of the data in the original data....
--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)

September 23, 2015 at 4:36 pm

#1828974
RE: Moving and restoring the db from latest backup -- Priority

Mitch C. Stein (9/23/2015)
I know SQL 2012 will back up and restore from network drives.
So will everything from 2005 and up. And, 2005 also had the "COPY ONLY" feature......
--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)

September 23, 2015 at 8:20 am

#1828807
RE: Are the posted questions getting worse?

WayneS (9/22/2015)
Holy cow... I've been avoiding that thread, and curiosity got the better of me. Sure with it hadn't.
Everyone needs to just walk away from there. No more posting 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)

September 23, 2015 at 8:16 am

#1828803
RE: Need Help in Recursive Query in SQL using CTE

Now, if we could just get the OP to participate in his own thread... 😉
--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)

September 23, 2015 at 8:04 am

#1828797
RE: save real datatype in sql without converting to exponential

bkshn (9/21/2015)
Hello
I want to save 999999999 as real data in sql.
but it saved 1+E09.
Could you help me how can I save 999999999?
thanks alot
The question here is, do you know 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)

September 23, 2015 at 6:54 am

#1828762
RE: DBA - Where in your organization?

We have what I call a DevNetOps team made up of several teams.
[font="Arial Black"]OPS[/font]
Infrastructure, Windows, Email, VMs, Overall Security, Telephone System, UPS, Emergency Diesel, VPN's, DR, Remote DR, backups 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)

September 22, 2015 at 9:50 pm

#1828648
RE: How to Import Data to SQL Server from Access Database using TSQL Script

Here's what I used to read from an ACCESS table using the ACE drivers. This will also read from an ACCESS View or Stored Query... no linked server required....
--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)

September 22, 2015 at 9:10 pm

#1828642
RE: How to Import Data to SQL Server from Access Database using TSQL Script

Ok... once you've downloaded from the URL that I gave in my previous post, you need to following these (below) instructions instead of the ones that are posted on 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)

September 22, 2015 at 8:41 pm

#1828639
RE: How to Import Data to SQL Server from Access Database using TSQL Script

pietlinden (9/22/2015)
Just wondering, where are the 64-bit ACE drivers available? I seem to have the 32-bit ones, and SQL Server is throwing a fit. (I suppose I could do...
--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)

September 22, 2015 at 8:28 pm

#1828637
RE: 1st Time?

serviceaellis (9/22/2015)
Ok, example of how to do that?
Understand that until you posted code, I didn't have table names, column names, nothing... it's important to post the whole problem 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)

September 22, 2015 at 8:21 pm

#1828636

Viewing 15 posts - 19,531 through 19,545 (of 59,072 total)