Viewing 15 posts - 811 through 825 (of 1,179 total)
Yes, tempdb is taking the templet from model database hence second option will also work nicely 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 22, 2009 at 2:45 am
I preferably go with "Auto update Statistics" feature of sql server.
You can check the data and time of updated statistics with the following command:
DBCC SHOW_STATISTICS
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 22, 2009 at 2:37 am
You can write script to grant permission to tempdb and set this script to run as startup script when sql server starts
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2009 at 6:39 am
Can you run the update statistics on SQL Server 2000 and execute the query again in sql 2000?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2009 at 6:29 am
Yes, I do agree with Gila.
Always play safe when matter is for Production server.
Also keep the backup of all database including system database and keep it on other server...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2009 at 6:25 am
You can also perform detach / attach for your user database.
But yes you need to transfer Jobs, users etc.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2009 at 6:16 am
With help of perfmon you can check following memory related counters:
SQLServer:Memory Manager\Memory Grants Pending
SQLServer:Memory Manager\Total Server Memory (KB)
Memory\Pages/sec
Also you can add few more counters and check memory as well as...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 9, 2009 at 3:40 am
Hello,
You will get many stuffs on net as well as Microsoft Online Help.
But to kick start refer the following link:
http://www.sqlservercentral.com/Forums/Topic165125-92-1.aspx#bm165309
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 9, 2009 at 4:15 am
Generally I prefer default settings Auto update stats and let SQL Server decide when to update stats.
There is no harm in doing it manually but it may lead to overhead...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 3, 2009 at 12:49 am
I guess another CPU menas another computer 😉
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 26, 2009 at 5:24 am
run CMD command like "COPY <from location> <to location>"
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 26, 2009 at 5:23 am
It will depend on situation.
If you will be able to perform the tail log backup successfully than yes you will be able to recover data till 12:30 but keep...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 23, 2009 at 12:01 am
You create a stored procedure for reindexing by defining the database_name variable/cursor. It will take the database name from sys.databases.
Create a job and use this sored procedure to schedule at...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 22, 2009 at 11:40 pm
There should not be any licencing issue. As far as you are installing it on the single PC 🙂
Because COST of the 32bit and 64bit is same.
The only reason...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 22, 2009 at 11:26 pm
sqlcool,
It is not possible.
The work around is restore the backup with different db name. Do BCP / DTS to recover data to original table.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 22, 2009 at 11:15 pm
Viewing 15 posts - 811 through 825 (of 1,179 total)