Subscribe to this list via RSS Blog posts tagged in SQL Server
In the C++Builder of RAD Server, FireDAC + SQLServer connection.[JAPAN] I explained the FireDAC + SQL Server connection in the previous parallel processing. // Use FireDAC to MSSQL Server in parallel(std::vector<std::thread>)[JAPAN] The "japan post office data"(SQL import) used last time is used from RAD Server. We will create a new RAD Server project this time. That's C++Builder. I have created one resource data module(TTestResource1). And we prepared a data module(TDataModule2) for one FireDAC. We will create a single suffix for the resource. It is a mem...
Use FireDAC to MSSQL Server in parallel(std::vector<std::thread>)[JAPAN] std::thread exists.It is in the standard from C++11. Insert data in MS-SQL Server in this way. The data is a Japanese address CSV. that is, It is in the post office in Japan web site. The data looks something like this. "0600000","北海道","札幌市 中央区","以下に掲載がない場合","HOKKAIDO","SAPPORO SHI CHUO KU","IKANIKEISAIGANAIBAAI" "0640941","北海道","札幌市 中央区","旭ケ丘","HOKKAIDO","SAPPORO SHI CHUO KU","ASAHIGAOKA" "0600041","北海道","札幌市 中央区","大通東","HOKKAIDO","SAPPORO SHI CHUO KU","ODORIHIGASHI" It is a CSV mixed...
Creating and Identifying Deadlocks in SQL Server This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health extended event. Get the ultimate tool suite for cross-platform database management Embarcadero DB PowerStudio, a suite of award-winning database tools for DBAs and data professionals, uniquely offers comprehensive administration, development and performance tuning capabilities across all major database platforms which dramatically increases productivi...
Learn How to Make your SQL Server Queries Run Faster If you are using Microsoft SQL Server, here's a webinar that you won't want to miss. Make SQL Server Queries Run Faster Wednesday, May 20, 201511:00am Pacific / 1:00pm Central / 2:00pm Eastern Have you ever developed slowly running queries and wondered how to tune your own SQL Server queries? In this session, you will learn some T-SQL performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go o...
SQL Server Tip: Optimizer using Index Scan and not Seek! Other than coding, most of the time developers have to troubleshoot problems from their environments. Developers in SQL world would mostly face problems around error message, getting required output via T-SQL query and unpredictable performance of query.  One fine day somewhere in the world a one developer was troubleshooting a performance problem – just like any one of us. He noticed, even after a table has index on a column and if they use that column in where clause, SQL Server was...
Performance Improvements with SQL Server 2014 Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make it superior from previous model. If the features are appealing, generally customers are positive and forthcoming to pay little more than previous model. Above theory holds good for SQL Server product as well. It is expected that SQL Server 2014 should have some new enhancements as compared to the predecessor SQL Server 2012 version. In SQL Server 20...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...

Posted by on in Blogs
Ad-hoc SQL/POCO Queries in Entity Framework 4.0 Since version 4.0, the Entity Framework has had the ability to query un-mapped data and project it onto POCOs using ad-hoc SQL. Here, for example, is how we check the current SQL Server version: internal class SqlVersionInfo { public string Edition { get; set; } public string ProductLevel { get; set; } public string ProductVersion { get; set; } } private static SqlVersionInfo GetSqlServerVersion(ObjectContext conte...

Posted by on in Blogs
Sometimes, SELECT Really Is Broken We got a bug report from a customer the other day; a certain query in one of our web services was giving the following error: A column has been specified more than once in the order by list. Columns in the order by list must be unique. Seems clear enough, except that There was no duplication in the ORDER BY. Our DBA discovered that the "problem" reference was [Project2].[C5] ASC, which is an alias, not a real DB column name. It certainly appeared only once, but removing it made the error ...

Check out more tips and tricks in this development video: