Viewing 15 posts - 646 through 660 (of 5,393 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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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,...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
March 31, 2015 at 7:34 am
Sorry for the late reply. Which command line parameters are you using for BCP?
-- Gianluca Sartori
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...
-- Gianluca Sartori
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
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
March 31, 2015 at 4:07 am
Viewing 15 posts - 646 through 660 (of 5,393 total)