Hierarchy data retrieval in SQL Server
Hierarchy data retrieval in SQL Server
Search Results
Search found 42327 results on 1694 pages for 'microsoft sql t sql'.
Page 342/1694 | < Previous Page | 338 339 340 341 342 343 344 345 346 347 348 349 | Next Page >
-
-
Linq to SQL Performance Considerations Part 2
Linq to SQL Performance Considerations Part 2Read the article
-
Microsoft Lowers Cloud Barrier To Entry
- by Herve Roggero
Once in a while, the technology stack changes enough to create a disturbance in the IT industry. Microsoft did just that today and has officially closed the gap with its #1 competitor: Amazon. What is remarkable is that Microsoft is no longer an alternative to Amazon, it is becoming a clear leader in that space. Some of the new features include official support for durable Virtual Machines with high availability (cross-geographic replication), free WebSites to try Azure, MySQL database at no charge, a new distributed low-latency cache feature, Linux support, support with existing VPN hardware for seamless on-premise integration, a new partner ecosystem and much, much more. Amazon had an edge against Windows Azure in the IaaS (Infrastructure as a Service) space, until now. With the latest release from Microsoft Azure, the gap has been filled. In fact, it seems Amazon may now have a gap to fill… This is great news to everyone; it seems that cloud offerings are becoming more standardized with the more mature cloud providers, and the management stack and quality of service of each cloud provider is increasingly becoming the differentiator. With today’s announcements, it is becoming clear that cloud providers are pushing hard to increase their service footprint and lowering typical barriers to entry such as support for open-source operating systems, free trial offers, higher availability, faster deployment times and simpler enterprise integration.Read the article
-
Determining Object Access Using SQL Server Profiler
Deanna Dicken examines an SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.Read the article
-
Recovering SQL Server 2008 Database From Error 2008
MS SQL Server 2008 is the latest version of SQL Sever. It has been designed with the SQL Server Always On technologies that minimize the downtime and maintain appropriate levels of application availa... [Author: Mark Willium - Computers and Internet - May 13, 2010]Read the article
-
Defining Indexes with SQL Server 2005
All about SQL Indexes - Query Optimizer, Index, Unique Index, Clustered Index, Full Text Index, XML Index and SQL commands to create, delete, and rename SQL indexes.Read the article
-
Sql Database Engine
Helper Class for .Sql Server Database EngineRead the article
-
SQL Server Style Wildcard Matching
Match SQL Server style wildcards in client code.Read the article
-
Truncate Log File in SQL Server 2005
A tool that facilitates the truncation of SQL log fileRead the article
-
How to create a Table with fields in a Access Database (ADOX and JET SQL)
Creating a simpleTable with fields in a Access Database using ADOX and JET SQLRead the article
-
Links to SQL Articles
- by Baskar B.V
This post would be updated with links to nice articles which i would come across in SQL Server (database). Default Trace in SQL 2005: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/Read the article
-
Why is Web SQL database deprecated?
- by user221287
I am making a hybrid Android app. At first I decided to use localStorage, after spending 2 days, I realized that it is very strange and so dropped it. Then, I picked up indexedDB, after spending today's whole day and actually getting the output in Google Chrome, it is not running inside a WebView of the android app. And I never used Web SQL database at all because it was deprecated. Anyhow, it has come to my notice that PhoneGap still uses Web SQL and android's browsers support it. Why was Web SQL deprecated in the first place? And will it be a good idea for me to go with Web SQL now?Read the article
-
Get month from the datatime column in SQL Server
Get month from the datatime column in SQL ServerRead the article
-
SQL Server 2008 message box - Unable to edit the table property
SQL Server 2008 message box - Unable to edit the table propertyRead the article
-
Set Vs Select statement in SQL Server
Set Vs Select statement in SQL ServerRead the article
-
SQL Server Service Broker - An Introduction
SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses SSBS' important features and how to use it in different scenarios.Read the article
-
SQL Server Technology Thirst
SQL Server Technology ThirstRead the article
-
ADO.NET Entity Framework and SQL Server CE 3.5
Learn how to use Microsoft's ADO.NET Entity Framework to connect to, consume and update a Microsoft SQL Server CE (Compact Edition) database.Read the article
-
Remove common substring from the strings in a column in SQL Server
Remove common substring from the strings in a column in SQL ServerRead the article
-
SQL SERVER Interview Questions
SQL SERVER Interview Questions contains 1 General Questions of SQL SERVER...…………………… 2 Common Questions Asked……………………………………… 3 Questions of SQL SERVER 2008……………………………Read the article
-
Inline variable assignments in SQL Server 2008
Inline variable assignments in SQL Server 2008Read the article
-
Find index associated with the table in SQL Server
Find index associated with the table in SQL ServerRead the article
-
Keyboard Shortcuts in SQL Server
Keyboard Shortcuts in SQL ServerRead the article
-
SQL Server Stored Procedures Comparer
Windows application that compares stored procedures between two SQL Server databaseRead the article
-
Basics of SQL Server 2008 Locking
Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.Read the article
