Viewing 15 posts - 1,501 through 1,515 (of 7,168 total)
Rod at work (3/21/2013)
March 21, 2013 at 12:58 pm
It could be page splits. What is the fill factor on the index you rebuilt and are you updating a variable length column (e.g. a VARCHAR or NVARCHAR) that either...
March 21, 2013 at 12:51 pm
You can script the jobs from prod using SSMS but note that it will include the schedules.
March 21, 2013 at 12:25 pm
Revenant (3/21/2013)
crookj (3/21/2013)
sing4you (3/21/2013)
Soreaching
breaking
Bad
March 21, 2013 at 12:12 pm
And just to confirm, when you run this in SSMS what does it do?
exec PHIL_App..Rpt_JobTransactionsSp 'SRMQDIC','ROD','B','HNS','0','B',null,null,null,null,'000','9999','1/1/2013','3/17/2013',null,null,null,null,null,null,null,null,'T',null,null,'1','0','1033'
March 21, 2013 at 10:55 am
skb 44459 (3/21/2013)
Yes In the code i am appending the Servername but i get same result with or without the ServerName.
Have you modified SSMS so you can see the entire...
March 21, 2013 at 10:02 am
skb 44459 (3/21/2013)
I am running the code from the SQL Server Management Studio.Do i need to specify the Server name , user name and password ?
I do not think you...
March 21, 2013 at 10:01 am
I just want to start out by saying that I have enjoyed our dialogue very much and that anything coming across as criticism is not meant to be taken as...
March 21, 2013 at 9:58 am
Anytime. Thanks for the feedback.
March 21, 2013 at 9:41 am
Batches or queries that do not have temporary tables can still use tempdb. For one of many possible examples, if the execution plan has a Sort operator and there is...
March 20, 2013 at 10:42 pm
64-bit SQL Server still uses the AWE APIs to allocate memory in Windows. No need to worry there. Just set 'max server memory' properly and off you go.
March 20, 2013 at 10:30 pm
Evaluation Edition is equivalent to Enterprise Edition in terms of functionality and affords 180 days of use. For all licensing compliance information though, never accept the guidance of someone on...
March 20, 2013 at 10:27 pm
Developing something like this yourself will takes years to perfect and will be low quality if you devote only a small number of resources towards it. Companies like MelissaData have...
March 20, 2013 at 10:23 pm
There really is not enough info to say for sure what would be best for you, but one misconception I picked up is "choke point is read/write speed of disk"...
March 20, 2013 at 10:18 pm
stephen 81278 (3/20/2013)
Check out this guide on StackOverflow - http://stackoverflow.com/a/13480576/524733
That links to a technique relevant for MySQL...this is a Microsoft SQL Server Forum :ermm:
March 20, 2013 at 5:55 pm
Viewing 15 posts - 1,501 through 1,515 (of 7,168 total)