Viewing 15 posts - 466 through 480 (of 1,179 total)
Check this out:
http://stackoverflow.com/questions/15375218/how-to-convert-columns-data-in-comma-separated-list
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 3:21 am
Attach execution plan too which will be easy to help you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 2:37 am
Ask your system admin to create a 'Task Scheduler' to begin this task at start up.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 1:01 am
It is OK if you use this On the test/dev environment but suggested not to use it On PROD server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 12:42 am
I guess you can achieve this through IF..ELSE and WHERE clause.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 12:38 am
What do you mean by tempdb clean up? Usually SP use tempdb for temporary calcuation and you need to fine tune stored proc which help to improve performance.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 12:29 am
Enjoyed the question, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 11:31 pm
What is the status on serverA sync with ServerB? Not sure how is your database on serverA? Refer following link which might help you.
http://technet.microsoft.com/en-us/library/ms189850.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 11:24 pm
If everything going fine do not worry. This is because of maintenance task. And I guess it happens after reindex?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 11:04 pm
It all depends on the application. I suggest to refer best practice naming convention and prepare the document. Also circulate the same to the development team before you proceed further.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 11:00 pm
It's all depends on DB size and application. Also you can have benchmark if your current application is running on other server.
However as rule of thumb log size is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 10:30 pm
How about SSRS?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 6:21 am
It will do much more than you think. Please refer SSIS in BOL for further detail.
You can also think about database import which also support Access source.
Refer following links which...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 6:18 am
SQLServerCentral is best option according to me. This is due to two things one is limitation of 140 character and another many might not help you as twitter is filtered...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 5:47 am
Check out the possibilities with SSIS.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 13, 2014 at 5:40 am
Viewing 15 posts - 466 through 480 (of 1,179 total)