Viewing 15 posts - 40,696 through 40,710 (of 49,552 total)
Are you talking about reporting services? Something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 1, 2009 at 5:35 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2009 at 6:26 am
Jeff Moden (2/27/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2009 at 6:12 am
Is the amount of data the same in both environments?
Are the indexes the same?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2009 at 6:02 am
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic666149-24-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2009 at 6:01 am
sudhakara (2/28/2009)
hi thnks ur reply but not able to access this link ..can u give me the correct one ?
Works fine for me.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 28, 2009 at 5:56 am
kevinsql7 (2/27/2009)
Thanks. I had to put the tablename in single quotes.
Yup. The example I posted was with a variable as a parameter. A string literal would go in quotes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 12:50 pm
DBCC UPDATEUSAGE
CheckDB with the data_purity option
Change page verification to CheckSum (from Torn page)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 12:34 pm
Viewing 15 posts - 40,696 through 40,710 (of 49,552 total)