Viewing 15 posts - 5,326 through 5,340 (of 7,505 total)
Is there a problem when using a temp table to generate your number ?
e.g.
create table #mytmptb (myNumber int identity(1,1))
set nocount on
declare @MyNumber int
insert into #mytmptb
output inserted.myNumber
default values
set...
January 18, 2008 at 7:12 am
my first impression ?
- just call the sproc have it return a rowset to a .net-dataset and the write the .net dataset to an xml-file.
(I don't know the coffee language...
January 18, 2008 at 6:54 am
just my 2ct.
- avoid dynamic sql
- add a language code column an just use one table
- maybe even partition on the language code column
- if you still want tables to...
January 18, 2008 at 6:44 am
functions in joins cause your perdicates to be NON-SARGable.
meaning indexes will not be used to serve the condition itself. (at least not that optimal)
These conditions will have to be handled...
January 18, 2008 at 6:39 am
- it installs the runtime libaries so it is able to support the failover.
- you need the extra client install at the second node,
if you want to have the...
January 18, 2008 at 1:47 am
Oh yes, use table_aliases in your queries !
Advantages are obvious.
And a human may even succeed to interprete your query way faster because it will be readable.
One thing MS...
January 18, 2008 at 1:39 am
Adam Haines (1/17/2008)Read through the article because it gives great insight to how to setup logging and what it does for compliance.
My day started awfull with huge network problems and...
January 18, 2008 at 1:26 am
AFAIK the only way is by starting a trace and investigating it.
cfr SQL Server and SOX @ http://www.sqlservercentral.com/articles/Security/3203/
January 17, 2008 at 7:56 am
...I might leave the editor on. I had a few people say that it distinguished me from a regular user....
Shouldn't that be a new attribute in your entity ? :Whistling:
.......
January 17, 2008 at 7:48 am
When I'm on the net ...
Most of the time I spend in forums.
Most of the time I tend to forget the blogs.
Maybe the SSC startpage should also have a part...
January 17, 2008 at 6:14 am
the mighty BOL states :
Remarks EXP
The constant e (2.718281…), is the base of natural logarithms.
The exponent of a number is the constant e raised to the power of the number....
January 17, 2008 at 6:00 am
Nice article series :w00t:
btw the blog url is wrong !
It should be http://blogs.sqlservercentral.com/members/Andy-Warren.aspx
January 17, 2008 at 1:58 am
...
The following code will produce dates in a reverse order from the EndDate to the StartDate... no cursor... no explicit loop... runs nasty fast... on repeated use, generates...
January 17, 2008 at 12:57 am
- second first rule for any rdbms : tell the system what you know !
- If you can have 'yes' or 'no' why would you accept 'maybe' ?
- the fact...
January 17, 2008 at 12:36 am
Just my 2ct ...
changing username may cause some "broken" references in forum replies, etc.
(e.g. there a some replies like "to alzdba ...." If I change my username to JohanBijnens that...
January 17, 2008 at 12:01 am
Viewing 15 posts - 5,326 through 5,340 (of 7,505 total)