Viewing 15 posts - 31 through 45 (of 122 total)
Splitting a table can have advantages.
If it is a table that has several fields that are frequently read
but never updated and other columns are read and updated.
I ran into...
March 3, 2003 at 6:01 am
DBCC USeroptions gave the answer
sorry for the question....
March 3, 2003 at 5:15 am
Thanks Fergusson.
I have tried numerous things and nothing seems to work.
What i do now is insert them in a mem table and then select the value I want.
Not a nice...
March 3, 2003 at 2:53 am
Antares you are missing the point here,
it is indeed modified from the books online.
But the case doesn't use a single column, it uses 12 different columns spread over 3 tables.
So...
February 28, 2003 at 6:26 am
Yes in this case that works.
But it was a simplified example.
Th real query doesn't take a value from a single column or table but uses
3 joined tables and several fields...
February 28, 2003 at 6:09 am
Thanks for the help, but I tried it already it give me :
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'Example'.
February 28, 2003 at 5:55 am
I have such a solution.
It works with VSS and OSQL Scripts.
But it is not as good as it should be. Because
the whole system starts or stops with 'Labeling in VSS'
and...
February 24, 2003 at 6:04 am
Just a few remarks because I recognize the problem but see a few problems with the solution..
1. Is the database diagram still readable ?
2. Are the queries where a couple...
February 20, 2003 at 2:20 am
select datepart(dw,datefield) from tablexy where datefield ...
The weekday (dw) datepart returns a number that corresponds to the day of the week, for example: Sunday = 1, Saturday = 7....
February 19, 2003 at 7:40 am
February 19, 2003 at 5:57 am
Yep you can, have a look at the script
Log DISK IO statistics per Database file!!!
that is posted on this site, i think it does what you are asking.
It...
February 19, 2003 at 3:18 am
Well something weird went on with those usertypes so no i changed you rquery to :
declare @tbl sysname
set @tbl = 'table2'
select sc.name as 'ColumnName',
...
February 18, 2003 at 5:51 am
DOes this one also works for usertypes ?
February 17, 2003 at 7:17 am
Crappy,
You are right it is called for every record.
But this is how I see them all the time.
If your function is different and is not used in a select...
February 12, 2003 at 1:12 am
You never have to crack or decrypt 'with encryption'.....
Just make sure you have the profiler on when the sproc is created.....
( hi hi )
February 11, 2003 at 9:33 am
Viewing 15 posts - 31 through 45 (of 122 total)