Viewing 15 posts - 151 through 165 (of 1,179 total)
You create a SSIS package to insert data from xls to table. You can create a job to execute this SSIS package. Also you can schedule it as well as...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 27, 2014 at 2:49 am
Thank you, Steve.
One more question on SQL new feature of memory-optimized filegroup.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 26, 2014 at 11:40 pm
Based on your requirement you need to work out; follwoing questions will help you to narrowdown the options:
Howmuch downtime is acceptable?
Howmany Databases on the SQL instance?
What is the storage you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 26, 2014 at 6:13 am
Execute following command and check the recovery model of the user databases on which you do have issue.
select name, recovery_model_desc from sys.databases
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2014 at 3:41 am
Good one. Thank you Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2014 at 3:26 am
I noticed my full backups went from 28GB down to 4GB. The db properties under General, Database says the size is 33033.63MB with 27.36MB free space.
It's 27.36 MB...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2014 at 3:25 am
Totally agreed with everybody. Though db is in SIMPLE recovery reindex will surely affect the log size. If not check for any long open transaction.
By the way what is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 22, 2014 at 5:45 am
Thanks Steve for the question.
It has also been notice that Log file viewer is not displaying all the option at a time. If you open from SQL Server logs it...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 22, 2014 at 12:55 am
In that case looks like resource crunch on the server. Check your server for any harware bottlenack.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 6:53 am
but why it is taking more time only during my application launch? even pre-allocated memory is there for SQL server.
You mean once your application launch everything become normal?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 6:42 am
There are two ways:
One you can run RESTORE VERIFYONLY command to check and verify the backup.
Second you can restore the backup in test environment.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 6:38 am
In addition to above, when sql server started you may also see the messages for rollback transaction and rollforward transactions in the database. which is nothing but based on checkpoint...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 6:31 am
You can drop the article quietly but when you add the article to publication you must need to start the snapshot agent.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 6:02 am
Check the SQL log for detail action.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 5:59 am
What kind of application you are using on database server? As best practice microsoft recomend to have dedicated database server.
Check for any hardware bottlenack. Are you facing issue for...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 5:58 am
Viewing 15 posts - 151 through 165 (of 1,179 total)