Viewing 15 posts - 331 through 345 (of 2,038 total)
Hi Zahran
Little quote from BOL
When an MD5 hash algorithm is specified, the probability of HashBytes returning the same result for two different inputs is much lower than that of CHECKSUM.
Keep...
September 7, 2009 at 3:37 pm
Nope, it's just a table containing sequential numbers (1, 2, 3, 4, 5, ...) but there are many solutions which can be done with. You should read the article posted...
September 7, 2009 at 3:04 pm
Good morning Paul 🙂
Paul White (9/7/2009)
Not sure we can spare 'thousands' though - the place will seem empty in October 😀
You can - and you do :-D. Every year at...
September 7, 2009 at 3:02 pm
No databases but development?? Come on guys and gals, what kind of applications should that be? The whole world of developers create things like calculators or screen savers? 😛
I'm no...
September 7, 2009 at 2:52 pm
Hi Pedro
Why do you need a GUID as primary key? SQL Server works much better with INT primary keys.
If you really need a GUID primary key, you should avoid to...
September 7, 2009 at 2:41 pm
Hi
Use a joined UPDATE statement instead of all those sub-queries. It should be faster, more readable and eliminates problems with bulk operations like DELETEs of more than one row.
Greets
Flo
September 7, 2009 at 8:11 am
claudiosil100 (9/7/2009)
Why you say the 3rd parameter it's the best solution? 🙂
A third parameter gives you the possibility to use both ways from everywhere. If you call your SP1 (the...
September 7, 2009 at 8:08 am
claudiosil100 (9/7/2009)
Flo my English is so bad you could not see the problem? :unsure:
Your English, my English, our English - who cares :hehe:
Finally we know what we are speaking...
September 7, 2009 at 7:47 am
claudiosil100 (9/7/2009)
Msg 6819, Level 16, State 5, Procedure spiappGetTrv, Line 22The FOR XML clause is not allowed in a INSERT statement.
Oups... didn't ever try this with FOR XML and didn't...
September 7, 2009 at 7:44 am
claudiosil100 (9/7/2009)
IF @SP2
SELECT field1, field2, field3
...
September 7, 2009 at 7:34 am
Hi Cláudio
claudiosil100 (9/7/2009)
My usp_TestXML return an XML, using FOR XML RAW that it's used by another users/applications I can't modify to...
September 7, 2009 at 7:29 am
Hi claudiosil100
Try this:
---==============================================
-- we test on tempdb
USE tempdb;
GO
---==============================================
-- a procedure which returns XML
IF (OBJECT_ID('usp_TestXML') IS NULL)
EXECUTE ('CREATE PROCEDURE usp_TestXML AS SELECT 1');
GO
ALTER PROCEDURE usp_TestXML
AS
SELECT...
September 7, 2009 at 6:53 am
Paul White (9/7/2009)
It's good to hear you are keeping busy anyway 🙂Though the management side of things sounds quite dull.
The management side of things is dull! I would like to...
September 7, 2009 at 4:59 am
Paul White (9/7/2009)
But for a table which just needs sequential row numbers adding to it, even 2008 doesn't have a faster method.
It depends. In SQL Server 2005/2008 you can avoid...
September 7, 2009 at 3:37 am
Hi Paul
Paul White (9/6/2009)
2. This method runs in less than half the time (2005 only):
This script was just a little trick for SQL Server 2000 and previous versions ;-). There...
September 7, 2009 at 2:08 am
Viewing 15 posts - 331 through 345 (of 2,038 total)