Tag Info

Hot answers tagged

2

I did a little bit more research and found the answer to the problem. Even though the first parameter for DBMS_OUTPUT.PUT_LINE is listed as item in the 10g documentation for DBMS_OUTPUT. The actual name for the parameter is A. You need to bind the name using DBMS_OUTPUT.PUT_LINE(A => 'random text'). The actual parameter names for stored procedures can ...


2

Just in case this helps, I'm posting some code that might help you work out what account that sid represents: USE tempdb; GO -- to translate SID in binary format to AD format CREATE FUNCTION [dbo].[fn_SIDToString] ( @BinSID AS VARBINARY(100) ) RETURNS VARCHAR(100) AS BEGIN IF LEN(@BinSID) % 4 <> 0 RETURN(NULL) DECLARE @StringSID VARCHAR(100) ...


2

Management Studio is the tool you should probably be using to manage a SQL Server database. You can download SQLManagementStudio_x64_ENU.exe from here: http://www.microsoft.com/en-us/download/details.aspx?id=43351 For the C# side, you could use Visual Studio: http://www.visualstudio.com/downloads/download-visual-studio-vs#d-express-windows-desktop


2

I recommend not using Entity Framework with anything else other than SQLSERVER. And then LINQ to SQL may be better. lightspeed was recommended to me as a better product. I personally have not used it.


2

The syntax you're looking for is here CREATE {DATABASE | SCHEMA} ... [PAGE_SIZE [=] size] ... [DEFAULT CHARACTER SET charset [COLLATION collation]] ... [DIFFERENCE FILE 'filepath'] size ::= 4096 | 8192 | 16384 Also check out this page and this link from it specifically about case insensitive searches and collations on columns. ...


2

We've used Change Tracking to handle this. We've found it lightweight and easy to set up and administer. The largest system's moving tens of thousands of rows (from a table containing millions) per day without signs of stress. Of course your configuration will dictate your throughput. It's big cousin - Change Data Capute - will handle the case where you ...


2

Is the default setting for Sql Server comparable to "innodb_flush_log_at_trx_commit = 1" or to "innodb_flush_log_at_trx_commit = 2"? No. Assuming similar hardware, SQL Server should be just as slow as MySQL, since both would have to flush the commit for every row. Therefore there must be something else at play, very likely in the (not posted) C# code ...


2

Yes, you can do this, and in fact with just 2 data centers you really have no other choice. Essentially, whenever you do not have a primary you can still do a reconfig but you must pass in {force:true} to make it happen on a non-primary node. This is listed in the docs for the rs.reconfig() command and in detail (with examples) as part of a tutorial which ...


2

Your query actually needs to use two properties of the CONTAINSTABLE function- <maximum distance> and <match_order>. Using CONTAINSTABLE(OpinionDocuments, HTML, 'NEAR((Foo, bar), 0, TRUE)') AS KEY_TBL Specifies to find "Foo" near "Bar" with 0 search objects between (<maximum distance> ", 0,") and in the order specified ...


1

When i did a systems analysis module in my years at university, i was doing my computer science degree. One thing our lecture told us all at the time was something we couldn't comprehend. "Strictly speaking, there is no wrong or right way to approach DBs" As computer scientists this is hard to swallow. lets look at your example: Ok, so you have ...


1

Note, that I assume C# (since this language is present in tags) and Entity Framework. Both approaches assumes, that entity types are inherited from abstract, non-persistent base entity type, which accumulates 75% of fields, so the code base discussion is not relevant. Pros of Table-Per-Hierarchy (all descendants are stored in single table): database ...


1

At the time of this writing, there is not public repository for Connector/NET, if you have performance/scaling improvements you are welcome to contribute them (together with a bug report) at bugs.mysql.com.


1

The more SSISic way of doing this would be through Expressions. Despite seeing multiple variables here, don't worry about them. I have found that when people try to do too much with an Expression, diagnosing and debugging bad logic will leave you reaching for the nearest blunt object. Variables FlatFileConnection, string. Value = ...


1

That C# script reads the file and executes each line from it. That works fine beacause the file contains only one line statements. If your T-SQL structure from your file is the same, then that C# code will work for you. You can check that by opening the file with Notepadd++. Cheers,


1

I did the same thing as Scott Chamberlain with the Itenso RTF DLL, but in my case there was a LOT more work that had to be done before this could be marked as SAFE in my SQL 2008R2 database. First, like Scott, I had to remove the reference to System.Drawing. I found the easiest way to do that was to remove the reference, recompile and then rewrite the bits ...


1

you can follow the tutorial in this link in-order to use PostgreSQL under C# and .net framework http://www.codeproject.com/Articles/30989/Using-PostgreSQL-in-your-C-NET-application-An-intr for managing the database side you can use aquafold (in my opinion one of the best database management for PostgreSQL check the following link http://www.aquafold.com/), ...


1

Your options are pretty limited. You can create a shell database and then use something like SQL Compare from RedGate to compare the schema and migrate the schema. Then possibly do a Data Compare to script out the data and migrate it. Alternatively, you could use the export option in SQL Server to export a bunch of tables which will recreate the tables on ...



Only top voted, non community-wiki answers of a minimum length are eligible