Viewing 15 posts - 301 through 315 (of 1,479 total)
Next time pleas include a small script that creates the table and inserts data instead of drawing a table. This will save time for anyone that tries to help...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 15, 2012 at 8:36 am
Were either or both of these set up by a recruiter? First sounds like confusing data entry with DBA. Second sounds like generic DBA position but they forgot to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2012 at 8:57 am
Few years ago I've had very strange interview. I was asked all kind of strange questions that had nothing to do with my ability to work as a DBA....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2012 at 8:34 am
Can you post a URL to the article? I've just checked it on 2 tables and get 2 query plans with almost the same cost. Maybe there...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2012 at 6:07 am
Yes. When you'll grant him the permission, it will be written in the log and when that log will be restored at the secondary database, the user will be...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 8, 2012 at 10:54 am
Users don't get any permissions by default. The users should be granted permissions. When you have a secondary database from log shipping, the database cannot be modified, so...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 8, 2012 at 10:20 am
If the job doesn't run at all check the fallowing:
1) Is the SQL Server is up and running?
2) Is the job enabled or disabled?
3) Is the job's schedule is enabled...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2012 at 6:58 am
What is the error that you are getting when you run the job?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2012 at 6:57 am
I ran the script and after the select statement, the statistics were created. Are you sure that the statistics were not created on your server?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2012 at 6:28 am
Can you post a small script that reproduces the problem (e.g. create table, insert test data, create the statistics and then the statistics are not created)?
About the statistics that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2012 at 6:03 am
Take a look at this article - http://msdn.microsoft.com/en-us/library/ms345408(v=sql.90).aspx. You can start SQL Server at special configuration (single user and only master database is up) and then issue alter database...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2012 at 5:54 am
If the login is part of sysadmin server role, then he can do everything on the server and you can not limit his actions. You'll have to to remove...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 1, 2012 at 5:41 am
I'm assuming that you want to increase the file's size. You can do it with Alter database statement. You can read about it and see an example...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 10, 2012 at 5:52 am
Do you have any triggers on the tables? Any indexed views on the table? Are all inserts that you are doing are insert values or are they insert-select?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 26, 2012 at 2:40 am
I'm sorry, but I don't understand what you want. You can get the difference between 2 datetime values by using the datediff function. This will return a...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 26, 2012 at 2:06 am
Viewing 15 posts - 301 through 315 (of 1,479 total)