Viewing 15 posts - 4,531 through 4,545 (of 7,496 total)
Gayathri.Varadarajan (9/12/2008)
September 12, 2008 at 5:20 am
Many times, this kind of issue points to the upmost advantage of using surrogate keys (which don't have a symantic payload at all, but their strict value).
Change of...
September 12, 2008 at 3:09 am
That is indeed a valid workaround if this is a singleshot operation (upgrade, bugfix,...)
September 12, 2008 at 2:46 am
If you want datetime info, your best choice is a column of the datetime data type !
You'll get a bunch of datetime functions to surve you !
Rule number 3:...
September 12, 2008 at 1:02 am
Gayathri.Varadarajan (9/12/2008)
...The on update cascade is not a preferred option.....
Then don't update PKs !
If you have FKs pointing to that parent table (I sure hop so), and you realy need...
September 12, 2008 at 12:47 am
Isn't this one in Steves build list ? http://www.sqlservercentral.com/articles/Administration/2960/
September 12, 2008 at 12:43 am
did the "restore database" step succeed ?
(what's it output)
can you perform sp_helpdb 'test'
September 12, 2008 at 12:18 am
Euhm.... no. It does not produce the same result as show client stats.
Test it and you'll see it reports on object base (stats io).
You can then compare that to what...
September 12, 2008 at 12:13 am
I have the impressions it comes to your output capturing way.
Use this:
SQLCMD -E -S .\SQL2000PE -d master -i ".\Osq_Test.sql" -o ".\Osq_Test.txt" -w340 -n -h-1
my Osql_test.sql contains:
/* just produce an output...
September 12, 2008 at 12:05 am
you just don't !
Check BOL for timestamp datatype and you'll figure out it is a type that sqlserver maintains itself ! (with every modification to the row !)
So you can...
September 11, 2008 at 2:17 pm
I always use
set statistics io on
set statistics time on
to get a grip rearding what SQLServer has to do for my query.
That in combination with the graphical execution plan opens...
September 11, 2008 at 2:15 pm
can you post the query you're trying to execute (including the table ddl) ?
September 11, 2008 at 11:55 am
riga1966 (9/10/2008)
My queryselect *
from
service_type_dim
where
service_type_code not in
(
select distinct service_type_code
from service_type_dim
inner join revenue_fact
on
service_type_dim.service_type_key = revenue_fact.service_type_key
)
In many cases a "not exists" outperforms your in-list.
It's certainly worth the test !
select...
September 11, 2008 at 11:32 am
from bol:
-w column_width
Allows the user to set the screen width for output. The default is 80 characters. When an output line has reached its maximum screen width, it is broken...
September 11, 2008 at 11:27 am
Did you get to the MS licensing doc ?
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
SQLServer2005Licensingv1.1.doc
It has some scenarios that may help you figure it out.
IMO it's best to monitor for a while before getting proc. licenses.
(Also...
September 11, 2008 at 11:18 am
Viewing 15 posts - 4,531 through 4,545 (of 7,496 total)