Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,211 through 21,225 (of 59,072 total)

RE: Rebuild index

Barcelona10 (3/19/2015)
hi ,
Is it possible to reclaim space after rebuilding indexes(shrinking is not an option).
Thank you advance
No. Not directly. And the indirect method is a huge PITA.
Are 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)

March 19, 2015 at 9:51 pm

#1785266
RE: Common Mistakes

According to the interviews that I've done in the last 3 years of Front-End Developers, Database Developers, and DBAs, the biggest mistake made is not knowing what they don't know...
--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)

March 19, 2015 at 9:35 pm

#1785265
RE: Update with Recursive CTE?

NP. At least this ol' brain remembered who showed me. Thanks for the confirmation. 😛
The numeric method won't work on VARCHARs that have non-digit-only characters in them 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)

March 19, 2015 at 9:08 pm

#1785263
RE: Report Builder 3.0 Expression to extract 2 parts of a string

Apologies for the extreme delay. The following demonstrates one way to do this.
--===== This just creates a table and populates it with sample data all on the fly.
...
--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)

March 19, 2015 at 8:44 pm

#1785262
RE: Update with Recursive CTE?

isaac.asher (3/19/2015)
My idea was most definitely painful...... and I figured someone out there had a simple solution. Mr or Mrs 500 had exactly the solution I needed! Thank...
--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)

March 19, 2015 at 6:06 pm

#1785254
RE: Call Stored Procedure from a Function

Sean Lange (3/19/2015)
Jeff Moden (3/19/2015)
Sean Lange (3/19/2015)
Nuhamovici (3/19/2015)
Can you share the code that does this? Calling sp_who from within a function?
Why? What could you possibly gain from calling a stored...
--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)

March 19, 2015 at 5:09 pm

#1785248
RE: Missing green arrow on the sql server icon in object explore

I'm a richer man thanks to your 2 cents. Thanks.
--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)

March 19, 2015 at 5:04 pm

#1785246
RE: Call Stored Procedure from a Function

Sean Lange (3/19/2015)
Nuhamovici (3/19/2015)
Can you share the code that does this? Calling sp_who from within a function?
Why? What could you possibly gain from calling a stored proc from within 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)

March 19, 2015 at 9:36 am

#1785110
RE: Performance Tuning Questions

rwitt 95744 (3/18/2015)
Greetings,
I have been using actual execution plans & Database Engine Tuning Advisor to analyze performance. My questions pertain to interpreting exactly what Database Engine Tuning Advisor is telling...
--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)

March 18, 2015 at 9:10 pm

#1784969
RE: Employeee Benefits Database

sasansamani (3/18/2015)
Yes this was homework.....
When tried to solve problem I determined the relationship between Employee and Benefits is many to many but I cant determine the bridge class. I mean...
--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)

March 18, 2015 at 8:37 pm

#1784966
RE: How to get FileName and TimeStamp of the file from a directory without using xp_cmdShell

SQLCurious (3/18/2015)
Thanks, Jeff. I tried using xp_DirTree but it only gets me the file names. I need to sift through the files based on the file types and their create/modified...
--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)

March 18, 2015 at 5:30 pm

#1784953
RE: SQL Help: Running row Total with Thresholds.

pietlinden (3/18/2015)
Okay, what version of SQL Server are you using, because this has zero to do with SSIS? This works in 2012, and I think in 2008.
Credits to Navy...
--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)

March 18, 2015 at 5:21 pm

#1784949
RE: Update with Recursive CTE?

isaac.asher (3/18/2015)
I have a list of account numbers stored in a table and am trying to update all account numbers to be 10 digits long. Some accounts will be...
--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)

March 18, 2015 at 5:18 pm

#1784947
RE: SQL Help: Running row Total with Thresholds.

subahan_syed (3/18/2015)
Hello Team -
I have a data table in below format and the need the desired output in 2nd table format
TABLE1
RANKBOOLEANREVENUE
1TRUE 100
2FALSE150
3FALSE200
4FALSE250
5FALSE300
6FALSE350
7FALSE400
8TRUE ...
--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)

March 18, 2015 at 5:15 pm

#1784945
RE: How to get FileName and TimeStamp of the file from a directory without using xp_cmdShell

SQLCurious (3/18/2015)
I want to write a stored procedure or a simple T-SQL snippet that takes a parameter "Directory Path" and gives me the name and datetimestamp associated with each of...
--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)

March 18, 2015 at 5:13 pm

#1784944

Viewing 15 posts - 21,211 through 21,225 (of 59,072 total)