Viewing 15 posts - 181 through 195 (of 375 total)
J
I just pointed out that the OUTPUT in SQL implementation is not a pure output parameter and can cause issues if not used carefully.
In most cases (depending on your...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 12:17 pm
GSquared,
You presented a nice case for sequential transactions. I need a good case that will prove that the nesting the way it is implemented really works and is usefull....
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 11:22 am
GSquared, with all due respect - SQL pretends to nest transactions :). If the last ROLLBACK uncommits all your pervious work this is not nesting in my book.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 11:06 am
Lee,
Few comments and warnings on what might bite you in the future.
1. Calling SPs from another SP is not a big deal and has nothing to do with set based...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 12, 2009 at 10:51 am
The difference between your script and mine is the usage and the output it generates. The objective of my script is to generate a set of insert statements that can...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 11, 2009 at 7:07 am
Before you start adding your miliseconds please remember that a datetime datatype is accurate to 3 miliseconds not 1 milisecond (and there are 999 not 99 of them 🙂 )....
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 10, 2009 at 9:58 am
Post your select statement you use to build your string.
I think one or more of the fields you are getting your data from is defined as NVARCHAR or NCHAR and...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 6, 2009 at 9:58 am
Can you post a sample SQL call you use to store your data.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 5, 2009 at 1:01 pm
I think it might be caused by a convesion to NVARCHAR somewhere
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 5, 2009 at 11:52 am
GilaMonster (3/4/2009)
tony (3/4/2009)
CREATE PROCEDURE UPDATE_TABLE_COUNT @NAME VARCHAR, @COUNT INT
Just to explain why. If you define a varchar (or char, nchar, nvarchar, binary, varbinary) without giving a length parameter, the default...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 5, 2009 at 9:45 am
Obsolete methods (proceudres, views, functions) are a big headache in a system that is evolving because they introduce confusion. Sometimes the business change forces you to modify a design of...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 27, 2009 at 8:29 am
Another thought.
I do not believe in backups.
I believe in double or triple backups. And if possible using different methods and media types.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 24, 2009 at 1:24 pm
I think there is also another aspect to this issue. Security. When you back up your database and store the backups on tapes, disks, online or whatever ather method you...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 24, 2009 at 12:50 pm
Nicely put Steve.
I will never give a definite answer if asked if something is going to work unless I test the crap out of it. Been burned too many times...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 12:52 pm
Bob,
you are right - I do not check anything, I measure time by checking a shadow of a stick and wind direction by licking my finger and sticking it out....
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 12:19 pm
Viewing 15 posts - 181 through 195 (of 375 total)