Viewing 15 posts - 166 through 180 (of 1,179 total)
Good question, Igor. Enjoyed diging the inromation and basics.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2014 at 5:53 am
Grant Fritchey (5/19/2014)
free_mascot (5/19/2014)
If you have doubt and server is not production you can enable trace for the specific database and check the activities going on?
You can trace production too,...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 8:08 am
You can check the status in Replication monitor
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 8:04 am
Check if any disk SAN issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 6:26 am
You can use ALTER TABLE command.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 6:24 am
Refer following link which might be useful:
http://msdn.microsoft.com/en-us/library/cc627369.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 6:14 am
There are no direct relation between master backup failed and rebuild master.
Have you checked why master backup is failing? Rebuilding the master is not a solution.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 5:58 am
try DMV sys.dm_os_ring_buffers which might help you to get CPU info.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 5:54 am
Interesting one, thank you Andy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 5:37 am
Your IT department should must have kept a copy of the software which you are using?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 5:25 am
Can you post exact error while deleting records?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 4:01 am
If you have doubt and server is not production you can enable trace for the specific database and check the activities going on?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 3:57 am
For workload what are the things would like to monitor?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 1:36 am
Also you can use following to trim result:
SELECT
SUBSTRING (CONVERT(nvarchar(15), GETDATE(), 6), 4,6) AS Month;
GO
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 1:18 am
Try something like this:
SELECT
CONVERT(nvarchar(30), GETDATE(), 6) AS Month ;
GO
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2014 at 12:53 am
Viewing 15 posts - 166 through 180 (of 1,179 total)