Viewing 15 posts - 691 through 705 (of 1,179 total)
This is with respect to security and if it's that's easy who will trust the SQL Server? It's database security after all 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2011 at 10:30 pm
One more good question with good topic VLF 🙂
Simple logic, if this statement is True we never encounter LOG FULL in simple recovery. But we do not as it depnd...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2011 at 4:15 am
When you are transfering large data to new table; I suggest you create just basic structure of the table i.e. without indexes, rules etc.
Once transfer is done you can...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 31, 2011 at 2:43 am
Check the following link for the detail:
http://msdn.microsoft.com/en-us/library/ms189612(v=sql.90).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 31, 2011 at 2:37 am
I guess index statistics are stored on the database level e.g.
object: sys.indexes
and
Dynamic view: sys.dm_db_index_physical_stats
Index is nothing but bunch of data pages(cluster index) and index pages(non-cluster index).
You are talking about...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 8, 2010 at 2:12 am
Running profiler means you are capturing the information related to specific database / activity. For that SERVER has to collect the details and any activity on the server affect CPU/Memory/IO...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 19, 2010 at 11:47 pm
It depends on size of the data too!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 19, 2010 at 4:12 am
One more challenging question, thank you Dave.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 19, 2010 at 3:50 am
If your environment is 24x7 and having difficulty for downtime; you can check for ONLINE option while reindexing with ALTER INDEX command. Online index operations are available ONLY in SQL...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 19, 2010 at 2:50 am
The answer is "True" as far as I know refer the following link for reference:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 15, 2010 at 12:55 am
Splendid work!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 12, 2010 at 4:10 am
You can run a validation and findout which tables are out of sync. Compare the data between those tables which are out of sync. Lastly you can drop the problem...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 12, 2010 at 12:37 am
There are two types of SQL Server upgrade
1. In place upgrade
2. Side by side upgrade
refer following link for more details:
http://technet.microsoft.com/hi-in/library/cc966519(en-us).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 12, 2010 at 12:10 am
You can write scripts on OS level to monitor the services and if stoped send message through netsend to monitoring desktop.
You need to have third party tool like MOM, redgate...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 11, 2010 at 1:20 am
As a best practice you can restore the backup in test environment and execute the reindex on the specified table and check if the space available in the productin is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 11, 2010 at 1:05 am
Viewing 15 posts - 691 through 705 (of 1,179 total)