Viewing 15 posts - 40,711 through 40,725 (of 49,571 total)
Dean Jones (3/2/2009)
March 2, 2009 at 3:40 am
saravanantvr1984 (3/2/2009)
insert happening. If we using trigger we can do only for particular table,
but i...
March 2, 2009 at 12:53 am
Performance-wise it'll be about the same. However, as soon as you start using dynamic SQL you're creating a whole bunch of security issues and concerns, from greater permissions required (permissions...
March 1, 2009 at 10:26 am
Why do you want to pass an entire statement to a stored procedure?
March 1, 2009 at 5:37 am
The snapshot agent runs as a job. Don't give it a schedule and then, in your other job, when you want it to start, call sp_start_job with the name of...
February 28, 2009 at 2:58 pm
Ninja's_RGR'us (2/28/2009)
Have you found any advantages of using CS collation?
No.
Jeff Moden (2/28/2009)
What is the advantage to making a whole server case sensitive?
In the cases I worked on, it...
February 28, 2009 at 12:58 pm
ssismaddy (2/28/2009)
there is no much difference in data. say, it has 5 tables which are of total size 30gb in prod and 25GB in Dev.
That's more than enough to...
February 28, 2009 at 12:30 pm
What is the exact code that is running to create the temp table and what is the exact error that the person gets?
February 28, 2009 at 6:33 am
AShehzad (2/28/2009)
But without adding the user in DDLAdmin role, it was not able to create temp table.
How is he trying to create them? A temp table's name starts with...
February 28, 2009 at 6:26 am
Jeff Moden (2/27/2009)
February 28, 2009 at 6:12 am
Is the amount of data the same in both environments?
Are the indexes the same?
February 28, 2009 at 6:08 am
Mh (2/27/2009)
I am trying to create third column by concatenating values of col2 with a comma as follows:
Why?
February 28, 2009 at 6:07 am
Please post in an appropriate forum next time. The article discussion forums are for discussion of published articles
February 28, 2009 at 6:05 am
klnsuddu (2/27/2009)
In ORACLE, we have ROLLBACK; statement to rollback the changes
The statement is exactly the same in SQL Server. ROLLBACK or ROLLBACK TRANSACTION. The main difference is that in...
February 28, 2009 at 6:02 am
Viewing 15 posts - 40,711 through 40,725 (of 49,571 total)