Viewing 15 posts - 391 through 405 (of 1,179 total)
Check the permission. Is there any permission issue? All jobs are failing with same error?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 12:17 am
Replication will take care of all the SP and not the part of the SP. It is good that initial information comments to track the changes. If replication do this...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 12:14 am
Did anybody gave you incorrect link?
Anyway refer following correct link:
http://www.microsoft.com/en-us/download/search.aspx?q=sql+server+2008+r2
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 12:07 am
No it will not wipe out existing data. But fill the extended files with 0. i.e. if you do have file size 100 MB with data of 80 MB and...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 11:28 pm
You can also add clause
"where/and unit <> 0"
OR
"where/and unit > 0"
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 11:12 pm
check the code of job and study execution plan which will help you. Also ask your storage team to find out the details of disk issue at specific point of...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 11:02 pm
Refer this excellent article which is self-explanatory.
http://www.sqlservercentral.com/articles/FCI/92196/
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 10:57 pm
Indeed a good question Andy, Thank you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 10:49 pm
Is this production server? Do not try things on prod and make scenario worst. Do all your restore and R&D on junkbox.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 6:47 am
Any luck with UPGRADE ADVISOR?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 6:23 am
fyi... no need to configure 3GB switch as server is 64bit.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 6:18 am
SAMPLE CODE, you can replace ListPrice with various file extention.
---------------
USE AdventureWorks2012;
GO
SELECT ProductNumber, Name, "Price Range" =
CASE
...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 5:05 am
Good and easy one!
Thanks!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 4:28 am
How about using CASE or IF...ELSE to check .txt, .xls etc.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 3:52 am
How about using FILESTREAM?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 3:48 am
Viewing 15 posts - 391 through 405 (of 1,179 total)