Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,611 through 17,625 (of 59,069 total)

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
RE: Enormous Transaction Log!

Brandie Tarvin (5/19/2016)
Ken McKelvey (5/18/2016)
tcalloway (5/17/2016)
I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, in a table...
--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 20, 2016 at 5:25 pm

#1880625
RE: Split Delimited String Across Fixed Number Of Columns

LoosinMaMind (5/20/2016)
I have the following in a table and need to transfer the single delimited string out into 99 Columns.
I'm afraid that the 99 Columns is a fixed template...
--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 20, 2016 at 4:40 pm

#1880620
RE: Can eliminating blocking / deadlocking ever be BAD for performance?

GilaMonster (5/20/2016)
It is possible to eliminate deadlocks in such a way that it degrades overall performance, I'm fixing a system which did just that.
In order to eliminate deadlocks on ImportantTableA,...
--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 20, 2016 at 4:26 pm

#1880617

Viewing 15 posts - 17,611 through 17,625 (of 59,069 total)