Viewing 15 posts - 2,401 through 2,415 (of 6,401 total)
Only you will be able to decide that.
Get a copy of the developer version of 2012, install it to a new server, restore a copy of the database, change your...
February 18, 2013 at 2:09 am
Play about with SQL Agent Alerts in a dev environment and see what they can do for you.
February 18, 2013 at 2:06 am
whats the output of this query in the DB in question?
select
*
from
sys.dm_db_index_physical_stats (DB_ID(),null,null,null,null)
where
page_count > 1000
and
index_type_desc <> 'heap'
February 18, 2013 at 2:04 am
Just keep pushing for more storage, sooner of later it will cause an issue on production and they will be forced to turn their hand.
I was in a similar position,...
February 18, 2013 at 2:01 am
Do you need the reports to be real time, or can there be a delay in the information being shown to the users?
You could look at Snapshots if you have...
February 18, 2013 at 1:49 am
You can't create a writeable snapshots as that defies the meaning and the way that snapshots work.
You will want to either archive data or look at using something like SQL...
February 18, 2013 at 1:40 am
Why do you want to compress your database? Running out of space on the drives? Can you not get additional storeage or move things about, add new data...
February 18, 2013 at 1:26 am
yep, the table needs to be in every db or you need to do the three part naming convention on the insert line
db.schema.table
February 15, 2013 at 9:46 am
Service probably changed now.
Check all your databases to see if they have a service broker service running in them then trace what is trying to call the service and the...
February 15, 2013 at 8:37 am
Did you create the table in the script?
If not comment out the line which does the insert in the other script?
February 15, 2013 at 8:37 am
Did you remove the space on the line with the comment?
February 15, 2013 at 8:14 am
Ask your developers if they have wrote a message broker would be the best bet.
February 15, 2013 at 7:13 am
Compare the connection strings between modules.
The error your getting is pretty self explanitory, the server doesnt exist of you dont have access to communicate with the server.
Debug your connection strings....
February 15, 2013 at 2:24 am
Perfectly normal, SQL will use as much memory as you have allowed it to even when no users are connected to the instance.
Take a look in my signature for the...
February 15, 2013 at 2:21 am
Viewing 15 posts - 2,401 through 2,415 (of 6,401 total)