Viewing 15 posts - 1,816 through 1,830 (of 3,061 total)
At the granular level I would store all figures in the currency of origin and I'll identify the currency.
I would also have a DIM_CURRENCY_CONVERSION table storing daily conversion rates for...
June 27, 2010 at 5:19 pm
koln (1/11/2008)
So now that you have climbed the ladder to Sr. SQL DBA....what is a next logical career choice...what do people do afterwards ?
What kind of shop are you working...
June 27, 2010 at 5:13 pm
useruser888 (6/27/2010)
June 27, 2010 at 5:06 pm
rgbarber (6/26/2010)
... to easily and quickly change data that was input from customers in the tables.
This is very bad mojo.
DBA owns the structure but not the data, user community owns...
June 27, 2010 at 4:58 pm
1- Get some background in relational theory, C. J. Date may be a good start.
2- At the same time build a home lab a.k.a. install SQL Server in a home...
June 27, 2010 at 4:53 pm
Ray K (6/23/2010)
PaulB-TheOneAndOnly (6/23/2010)
In this particular case I'll probably go with a denormalized solution - single table.
Just curious: why single table? When I first read the question, my initial...
June 25, 2010 at 12:07 pm
vsm198 (6/25/2010)
yes, I have approval to drop the database.
Did you get it in writting?
Does the organization uses a ticketing system? in the affirmative case ask for a fully...
June 25, 2010 at 11:59 am
mike 57299 (6/23/2010)SELECT order_hdr_id, customer_id, order_date, amount, city, state, zip INTO #Open From Order WHERE ship is null
Assuming script is creating #Open temp table, how about...
insert into #Open
select order_hdr_id,...
June 23, 2010 at 5:38 pm
You are correct. Thank you Wayne.
June 23, 2010 at 5:26 pm
I would start by trying...
select *
from TABLE_PRIVILEGES
where GRANTOR = 'offending_account'
June 23, 2010 at 3:02 pm
WayneS (6/23/2010)
June 23, 2010 at 2:41 pm
In this particular case I'll probably go with a denormalized solution - single table.
June 23, 2010 at 6:51 am
OR...
1- Rename your master table as TablenameBase
2- Create a view Tablename (same name as the original table) so all current queries could continue doing those ugly "select *")
3- Add new...
June 23, 2010 at 6:43 am
As far as I know the burden is on the Operating System and not on the database engine. When SQL Server needs more space and datafile is set to...
June 23, 2010 at 6:34 am
Since a persisted computed column is actually stored in the target table as opposed to a plain computed column that is virtual - why not use a standard column and...
June 23, 2010 at 6:27 am
Viewing 15 posts - 1,816 through 1,830 (of 3,061 total)