Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,406 through 21,420 (of 59,072 total)

RE: Help with Data type and size of the each row!!!!!!

Tac11 (2/27/2015)
In my database there is a big table and format is something like this:
CREATE TABLE [dbo].[MyTable](
[aaa] [uniqueidentifier] NULL,
[bbb] [uniqueidentifier] NULL,
[ccc] [nvarchar](max) NULL,
[ddd] [nvarchar](100) NULL,.......etc.........
There are some more columns with...
--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)

February 28, 2015 at 10:12 am

#1780891
RE: "Not a database file"

costache (2/26/2015)
hello everyone, I need help.
Dbf file corrupt and show message "Not a database file". I don’t know how to repair it
Waiting for reply.
"DBF" file? As in ".dbf"??? ...
--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)

February 28, 2015 at 10:08 am

#1780890
RE: Cannot create an instance of OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)".

Andrew Pankov (2/27/2015)
error message: Cannot create an instance of OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)".
SQL Server 2008 R2
User is getting this message trying to run a query in...
--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)

February 28, 2015 at 9:49 am

#1780889
RE: Are the posted questions getting worse?

Eirikur Eiriksson (2/28/2015)
Jeff Moden (2/27/2015)
Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!
Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on home,
To one...
--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)

February 28, 2015 at 9:30 am

#1780887
RE: permissions for connect any database

ANn -425914 (2/27/2015)
Thanks, It is good to know view any databases permission or view any definition implies that the account has a connect permission to the database.
But I cannot 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)

February 28, 2015 at 9:27 am

#1780886
RE: permissions for connect any database

JeremyE (2/24/2015)
You could add the permissions to the model database so each time a new db is created the permissions are there.
I'd strongly suggest against such auto-granting of privs.
--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)

February 28, 2015 at 9:24 am

#1780885
RE: What is the equivalent to Yes/No data type in SQL?

kennethrinderhagen (2/27/2015)
Yes/NoA logical field can be displayed as Yes/No, True/False, or On/Off. In code, use the constants True and False (equivalent to -1 and 0). Note: Null values are not...
--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)

February 28, 2015 at 9:08 am

#1780884
RE: Performance tuning

ANn -425914 (2/27/2015)
Thanks, a little not clear,
For our case I first created an index on terms table by using ID, SchoolID,
Note the ID is not a clustered index, there 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)

February 27, 2015 at 10:11 pm

#1780852
RE: Are the posted questions getting worse?

Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!
Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on home,
To one hundred bottles of beer...
--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)

February 27, 2015 at 10:00 pm

#1780851
RE: Super long running queries (bad users)

Eric M Russell (2/12/2015)
Jeff Moden (2/12/2015)
Killing even the most ridiculous users sessions is a really good way to need an updated resume. I know it takes a whole lot...
--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)

February 27, 2015 at 9:56 pm

#1780850
RE: Changing the clustered index

A low cardinality NCI will also cause such splits.
And that finally brings me to the point that I've been trying to make.
As you said, you shouldn't just do the "best...
--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)

February 27, 2015 at 9:46 pm

#1780849
RE: Convert 6 digit letter to month and Year

Abhiram (2/27/2015)
I have a column 062008 I want to display that number as 06/2008.
SELECT STUFF(yourcolumn,3,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)

February 27, 2015 at 5:17 pm

#1780835
RE: Changing the clustered index

ScottPletcher (2/27/2015)
Jeff Moden (2/27/2015)
It's also a bit odd for me to have you tell me not to be so concerned with the speed of imports when you, yourself, have posted...
--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)

February 27, 2015 at 4:43 pm

#1780831
RE: Convert 6 digit letter to month and Year

Abhiram (2/27/2015)
Can any one share how to convert 6 digit number to mm/yyyy.
Thanks in Advance.
What is contained in the 6 digit number?
--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)

February 27, 2015 at 4:17 pm

#1780827
RE: Changing the clustered index

It's also a bit odd for me to have you tell me not to be so concerned with the speed of imports when you, yourself, have posted just such a...
--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)

February 27, 2015 at 4:11 pm

#1780826

Viewing 15 posts - 21,406 through 21,420 (of 59,072 total)