Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,411 through 25,425 (of 59,099 total)

RE: Drop and Create table or Trunc table

wolfkillj (11/13/2013)
Jeff Moden (11/13/2013)
wolfkillj (11/12/2013)
Jeff Moden (11/11/2013)
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...
--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 13, 2013 at 5:10 pm

#1666242
RE: Are the posted questions getting worse?

Sean Lange (11/13/2013)
Grant Fritchey (11/13/2013)
Lynn Pettis (11/13/2013)
Lynn Pettis (11/13/2013)
It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!
Just finished the interview, and I feel...
--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 13, 2013 at 4:55 pm

#1666241
RE: Drop and Create table or Trunc table

wolfkillj (11/12/2013)
Jeff Moden (11/11/2013)
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...
--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 13, 2013 at 8:06 am

#1666096
RE: Today's Random Word!

Divine Flame (11/13/2013)
I don't understand the significance of this thread:cool:
Heh.... good. It must be ready to ship. 😛
--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 13, 2013 at 7:57 am

#1666089
RE: csv file data into a table

rightontarget (11/12/2013)
Hi all,
I am running SQL Server 2008R2 and trying to import .csv file data into a table.
The problem is that i have some values in the file that are...
--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 12, 2013 at 11:27 am

#1665820
RE: Bulk insert from file having varying number of columns

Lowell (11/12/2013)
here's my linked server example for a 64 bit folder full of text files that may help:
Very cool. I've not actually used the ACE drivers, yet (had other...
--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 12, 2013 at 9:54 am

#1665791
RE: Where to start to learn XML with SQL Server

Shadab Shah (11/11/2013)
Hi Floks,
I am trying to get my hands dirty with XML in SQL Server. I have tried MSDN and some other links which google suggested but i think...
--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 12, 2013 at 8:26 am

#1665744
RE: Test Coverage

From the article:
These days most testing of software is automated.
Oddly enough, I believe that's part of the problem with delivered software, today. There's nothing like a human using 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 12, 2013 at 8:20 am

#1665742
RE: Bulk insert from file having varying number of columns

Lowell (11/12/2013)
Dorthy Jeff Moden has a couple of posts on this, which i'd saved in the past:
here's the specific threads in question:
http://www.sqlservercentral.com/search/?q=%22Headerless+Ragged+Right%22
basically, he uses some dos commands to make sure...
--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 12, 2013 at 8:14 am

#1665740
RE: Split function in sql

Bhuvnesh (11/12/2013)
Jeff Moden (11/11/2013)
Have you ever tested that for performance?
I tested it for small strings but not for big ones.
I kind'a figured that. The code you're using 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 12, 2013 at 8:03 am

#1665735
RE: Cyberwar

Steve Jones - SSC Editor (11/11/2013)
I'd still argue this is more an internal developer professionalism issue more than a business case.
We, as people that teach and help others, need...
--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 4:22 pm

#1665610
RE: Access rights

Ed Wagner (9/19/2013)
Using the KILL command requires ALTER ANY CONNECTION. http://technet.microsoft.com/en-us/library/ms173730%28v=sql.100%29.aspx
Executing a procedure requires access to the database containing the procedure, EXECUTE on the procedure and whatever permissions 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 11, 2013 at 4:17 pm

#1665608
RE: Access rights

OnlyOneRJ (11/11/2013)
How to provide access to a user on SQL profiler??
You don't actually want a "user" to run SQL Profiler. Not even on the server side. You're 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 4:13 pm

#1665606
RE: Index tuning

namdinh4 (11/11/2013)
Is there another way to assess wide indices?
There's no guarantee but you could create the less-wide indexes, and see which indexes are used the most over time (provided 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 11, 2013 at 4:00 pm

#1665604
RE: Query Runs for Long Inspite of Indexes on table

sdennis (11/11/2013)
Yes,I need all the columns to be Inserted into another Table Actually as a refresh.
The clusteredIndex column is EngineResponseResultID
There is an Non clustered Index on Respondeddatetime and another non...
--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:56 pm

#1665603

Viewing 15 posts - 25,411 through 25,425 (of 59,099 total)