Viewing 15 posts - 226 through 240 (of 1,179 total)
paul s-306273 (4/29/2014)
Looks like I'm going to learn something everyday this week.Thanks for the 2014 questions Steve.
+1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 29, 2014 at 11:32 pm
I doubt if we can control this. As page split and data insertion is not always even.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 29, 2014 at 6:19 am
refer following thread for further detail:
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 6:04 am
Another good option to start with is sql or windows error log. Try to find out what kind of error message it has captured at the time of the issue...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 6:01 am
Refer following two articles which may help you:
http://support.microsoft.com/kb/321822
http://stackoverflow.com/questions/19730218/setup-replication-on-two-database-on-different-domain
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 4:36 am
Usually collation should be same on Prod and dev. Backup of the database also contain the details of collation and while restore it will keep the same collation. The only...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 4:30 am
First find out what are other applications are running on the server alongwith SQL Server. Than refer the Microsoft best practice document to have dedicated SQL Server database instance/server. Produce...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 4:21 am
In your query add colum qs.database_id, next to 'SP Name' and you will be surprise to see more than one db_id and when you remove the db_id() clause it is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 3:28 am
After the testing you can change the compitability level of the database to 2014. Also you can use sp_help_revlogin to migrate users. There are two aproach to the upgrade one...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 2:13 am
.MDB file is Microsoft Access database file. It could be created by SSIS package or used by SSIS package. Try to find the SSIS job which might related to this...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 1:00 am
Thank you, Steve.
Need to go extra-mile to find correct answer. Gain something. Good one.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 28, 2014 at 12:53 am
try this...
sp_helplogins gaurav
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 27, 2014 at 11:37 pm
All tempdb files are on T: drive and guess it is on cluster using SAN. Hence it will not distribute the load of I/O as LUNs are of same group....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 23, 2014 at 6:12 am
Any deadlock trace is on? Any information related to deadlock in sql log?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2014 at 4:06 am
Post the result of
sp_spaceused
sp_spaceused <table_name>
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2014 at 3:08 am
Viewing 15 posts - 226 through 240 (of 1,179 total)