Viewing 15 posts - 706 through 720 (of 1,825 total)
Jeff Moden (7/14/2010)
kchant (7/14/2010)
It may be worth checking your physical join operators as well, as I've encountered performance issues with stored procedures during migrations from 2000 to 2008...
Can you elaborate...
July 15, 2010 at 4:46 am
No ,
the permanent solution is to use a language neutral format.
So 'YYYYMMDD HH:MM:SS'
July 15, 2010 at 3:41 am
Its to do with how your client connects to the server.
The date format looks like its changing from DDMM to MMDD.
Try this page http://www.karaszi.com/SQLServer/info_datetime.asp
July 15, 2010 at 3:19 am
But , as Gail requested, DDL , execution plans etc are required to analyse the real problem.
July 15, 2010 at 1:57 am
Can you specify what the relationship is between the data in the rows ?
July 14, 2010 at 4:51 am
tasnim.siddiqi (7/12/2010)
I still wanted to use random generation, because I am a C programmer and was expecting to achieve same objectives using C codes and SQL. ....
If you want to...
July 12, 2010 at 11:58 pm
tasnim.siddiqi (7/11/2010)
@steve-2: Actually what I need is unique number in AppID column, as a new row is entered.
As previously stated , an identity column sounds like the job.
July 12, 2010 at 1:28 am
Why do you have the same structured data in different tables, to me that smacks of bad design ?
Personally here , if i had to, i would generate a view...
July 11, 2010 at 2:45 am
Chris Morris-439714 (7/9/2010)
Now, how often have you had to tell folks that there's no guaranteed order of results from a query unless there's an...
July 9, 2010 at 8:57 am
Have you ever twittered with "Cunning plan" ?
CaptnBlackadder Twitbot on it 🙂
July 9, 2010 at 8:38 am
Multi line table valued functions are to be avoided, inline table valued functions are to be embraced.
See Simon Sabin's session in the recent 24Hours of Pass , here http://www.sqlpass.org/LearningCenter/24Hours.aspx
July 9, 2010 at 6:55 am
Viewing 15 posts - 706 through 720 (of 1,825 total)