Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,641 through 17,655 (of 59,102 total)

RE: How to reduce the database size of the User DB's

Database admin(DBA) (5/23/2016)
Thank you jeff for your quick response.
Total size of the indexes is around 98GB.Waiting for your suggestions to proceed further.
Look at what I asked. I need 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)

May 23, 2016 at 4:26 pm

#1880900
RE: How to reduce the database size of the User DB's

Database admin(DBA) (5/23/2016)
Thank you all for your information/suggestions.
But for your information,The requirement is need to reduce size of the database and here Data file free space available around 98.5...
--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)

May 23, 2016 at 9:10 am

#1880802
RE: Backups now taking over 24 hours!

anthonystevens (5/23/2016)
Looks like it was a problem with our SAN. Thanks for the help and advise.
What kind of problem?
Also, why are you wasting valuable SAN space to store backups?
--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)

May 23, 2016 at 9:07 am

#1880800
RE: Dynamic Tablix

I guess my question would be... why do they want to build the 3 tables just to do a report? Personally, I wouldn't let such table creation to occur....
--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)

May 23, 2016 at 9:05 am

#1880797
RE: SQL Server Service won't Start After adding server to domain

crazy_new (5/22/2016)
I have tried using cmd but I got an error, can't remember what, will check and post. If I repair it using the setup, which folder do I point...
--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)

May 23, 2016 at 9:02 am

#1880795
RE: Monitoring Backups !!

How many servers do you need to report on and are all backups stored in a common area?
--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)

May 23, 2016 at 8:55 am

#1880793
RE: What is the best to remove xp_cmdshell calls from t-sql code

Mcin (4/4/2016)
Application connects to server using domain users. They have no admin privileges.
sa account is already disabled. It is application that works for few years already and now I'm maintaining...
--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)

May 23, 2016 at 8:40 am

#1880787
RE: How to reduce the database size of the User DB's

Database admin(DBA) (5/23/2016)
Thank you all your suggestions\help
But still some questions about this.
Yes I understood about Fragmentation part But My intention is how to reduce space from Data file which...
--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)

May 23, 2016 at 6:53 am

#1880728
RE: Solution TSQL Help!!!

angelreynosog (5/16/2016)
I have a database that was in Access, the amount to SQL Server and there, want to make a query to do the following, I have a table called...
--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)

May 23, 2016 at 1:23 am

#1880677
RE: How to get output from a select to a file ?

ben.brugman (5/13/2016)
From within the SQL environment (say a stored procedure) I would like to output the result from a select to a file on disk.
I know this is possible 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)

May 23, 2016 at 1:19 am

#1880676
RE: How to get output from a select to a file ?

Sergiy (5/23/2016)
ben.brugman (5/19/2016)
I do agree not allowing xp_cmdshell makes security tighter.
There is simply no way to actually disallow xp_cmdshell.
If you know one - please share it with us.
Heh... why...
--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)

May 23, 2016 at 1:18 am

#1880674
RE: The Politics of SQL Security

I simply ask if he'll enjoy reading about himself in the morning news after the company has suffered a breach. I also explain that customers can and do sue...
--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)

May 23, 2016 at 1:09 am

#1880671
RE: How to reduce the database size of the User DB's

The one reason I can think of to shrink database files is so that you could restore to a smaller machine in the case of an emergency or your copying...
--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)

May 23, 2016 at 1:04 am

#1880669
RE: Create a Tally or Numbers Table

RBarryYoung (5/1/2008)
Just google "tally table". The procedural (manual) form is used by schools a lot.
After 6 years, it would appear that Google has finally caught up with what 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)

May 21, 2016 at 7:48 pm

#1880647
RE: Recreating tables from a list of tables

Andre 425568 (5/19/2016)
Hi
I need a script to recreate a list of tables stored in a table. The fields have to be in the same order as the original table, and...
--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)

May 21, 2016 at 7:21 pm

#1880643

Viewing 15 posts - 17,641 through 17,655 (of 59,102 total)