Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,221 through 26,235 (of 59,102 total)

RE: Restoring a database and simultaneously increasing it's file size

If you buy the right disk defragmentation system, you can defragment SQL Server MDF, LDF, and NDF files while the system is up and running with little or no degredation...
--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)

August 14, 2013 at 6:59 pm

#1641623
RE: need help transforming row values to a table

ron morgan (8/14/2013)
how do i transform the result set or table columns eg. using tsql
See the following article for two different methods. Instead of using SUM(), use MAX().
http://www.sqlservercentral.com/articles/T-SQL/63681/
After 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)

August 14, 2013 at 6:35 pm

#1641621
RE: Modifying a stored procedure to point from PROD to TEST

Gerard Silveira (8/13/2013)
Hey Sean ,
The issue is I have a 4 part naming here, so Im looking for a method to move from PROD - TEST and TEST -...
--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)

August 13, 2013 at 3:54 pm

#1641175
RE: Shrink does not release space

jfgrocha (8/13/2013)
Hi =)
Im trying to shrink my production database, because we archived about 200GB of data, but - I don't know why - none space is released. I tried rebuild...
--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)

August 13, 2013 at 3:21 pm

#1641164
RE: Shrink does not release space

Snigdha Vartak (8/13/2013)
Try DBCC command to shrink database files.
Refer: http://technet.microsoft.com/en-us/library/ms190488.aspx
The OP said the he already tried to shrink the file without success. It won't matter if you use 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)

August 13, 2013 at 3:16 pm

#1641160
RE: Select statement can't modify

Sean Lange (8/13/2013)
I am confused. Are you typing in a query or using the Edit top 200 menu option? I would urge you to write your queries instead of using...
--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)

August 13, 2013 at 3:15 pm

#1641158
RE: Can you please any one explain?

Koen Verbeeck (8/11/2013)
Jeff Moden (8/9/2013)
techmarimuthu (8/9/2013)
Difference between CAST and Convert functions in SQL SERVER??
My recommendation would be to get into SSMS and press the {f1} key. There's a whole...
--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)

August 13, 2013 at 2:54 pm

#1641143
RE: Sorting Months By Number (SQL Spackle)

mohit.sharma 99294 (8/13/2013)
We can achieve same with date part.
SELECT [Month] = DATENAME(mm,Created_Date), Sale
FROM
(
SELECT Created_Date = '2012-12-01', Sale = 10000
UNION
SELECT Created_Date = '2012-02-01', Sale = 1000
UNION
SELECT Created_Date = '2012-03-01', Sale =...
--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)

August 13, 2013 at 7:30 am

#1640927
RE: How to Compile, Deploy and Consume a SQL Server CLR Assembly

Outstanding step by step article but (to cover the headline) I'm pretty sure that encryption and decryption Is possible in SQL Server. 🙂
--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)

August 13, 2013 at 7:20 am

#1640920
RE: Can a table have two primary keys?

ScottPletcher (8/12/2013)
seshu67 (8/7/2012)
Can a table have two primary keys
Absolutely no, period. The fact that separate unique constraints can be defined does not make them primary keys as well.
Similarly, 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)

August 12, 2013 at 11:08 pm

#1640785
RE: Would You Choose SQL Server?

chrisn-585491 (8/12/2013)
The market for skilled people is that great. It's to the point that they are having to "grow" their own developers for either technology stack.
According to the interviews 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)

August 12, 2013 at 10:49 pm

#1640783
RE: Who administers the SQL Backups in your company

Snigdha Vartak (8/11/2013)
We have IBM team handling servers and backups
Who is handling test restores? Are they even being done?
--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)

August 12, 2013 at 10:27 pm

#1640778
RE: Composite Index - Two Different Tables - Order By

I guess my intitial response would be...
1. Why are you doing a sort in a view? In other words, why is the sort required and what/where will 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)

August 12, 2013 at 10:10 pm

#1640776
RE: Covering Index Question

curious_sqldba (7/25/2013)
If i have a query which is doing a search on column patientnumber, and my covering index has patientname in key columns and patientnumber,address and SSN in include...
--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)

August 12, 2013 at 9:53 pm

#1640773
RE: How efficient is your covered index?

curious_sqldba (8/12/2013)
Thank you for sharing this article. Actually i had this question posted in forums also, so far no response, would like to know your thoughts please.
I have a view...
--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)

August 12, 2013 at 9:39 pm

#1640771

Viewing 15 posts - 26,221 through 26,235 (of 59,102 total)