Viewing 15 posts - 646 through 660 (of 5,394 total)
Which edition are you on?
Is the msdb database corrupted?
Have you tried a DBCC CHECKDB to see if something comes up?
Do you see the database as readonly?
SELECT is_read_only
FROM sys.databases
WHERE...
April 2, 2015 at 4:31 am
This is internal behaviour, which is not extensively documented.
As far as the additional abstraction layer, SQL Server handles it gracefully: you shouldn't be worried about that.
April 2, 2015 at 4:26 am
Unfortunately, the date format you are using is not supported in the CONVERT function.
You definitely should change the data type of that column: if it is supposed to store dates,...
April 2, 2015 at 4:25 am
The optimizer can decide to expand the view and the behavior is not completely predictable (as you have seen).
A quick fix could be to incapsulate the view in another...
April 2, 2015 at 4:00 am
Set a max server memory based on the available memory on your system (take into account other processes running on the box).
If you want to disallow paging altogether, grant the...
April 1, 2015 at 9:59 am
If you just need to monitor database/filegroup free space you can use my script here: http://spaghettidba.com/2014/09/05/database-free-space-monitoring-the-right-way/
However, FILEPROPERTY(filename,'SpaceUsed') will tell you how much free space there is in a database...
April 1, 2015 at 7:36 am
nagkarjun1 (3/31/2015)
If i wanted to use both default port and custom port, what happens if i put the values 1433, 3456 in IP all tcp/ip ports?
It won't work. You need...
March 31, 2015 at 8:15 am
SteveEClarke (3/31/2015)
Apologies -Command line;
Create format file;
bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] format nul -n -f C:\XMLExport\StockCodeFormat.xml -x -T
Create data file;
bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] out c:\xmlexport\StockCodes.xml -f C:\XMLExport\StockCodeFormat.xml -T -c
Try with character type format:
bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] out...
March 31, 2015 at 7:34 am
Sorry for the late reply. Which command line parameters are you using for BCP?
March 31, 2015 at 7:15 am
GilaMonster (3/31/2015)
Not efficient as it prevents index seeks, not that a text column can have indexes, but I don't like teaching bad options.
Exactly my point: a bad option is what...
March 31, 2015 at 4:45 am
This issue has been reported and fixed for 2012, but not backported to 2008 and 2008R2.
See here: https://connect.microsoft.com/SQLServer/Feedback/Details/757526
March 31, 2015 at 4:43 am
Nope, SP3 doesn't fix.
I guess you're out of luck then. SP3 is the final service pack for 2008R2 and no more updates are coming for this version.
March 31, 2015 at 4:38 am
sherm (3/31/2015)
This is the type of answer i was hoping to get. 🙂if you had type this in the first place, then i would not have shouted... hehe
I would have...
March 31, 2015 at 4:33 am
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
You're far too kind. I have told...
March 31, 2015 at 4:30 am
JohnyRotten (3/31/2015)
i'm on:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
seems there are some more issues...
March 31, 2015 at 4:07 am
Viewing 15 posts - 646 through 660 (of 5,394 total)