Hierarchy data retrieval in SQL Server
Hierarchy data retrieval in SQL Server
Search Results
Search found 27658 results on 1107 pages for 'sql dba'.
Page 307/1107 | < Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314 | Next Page >
-
-
Truncate Log File in SQL Server 2005
A tool that facilitates the truncation of SQL log fileRead 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
-
Microsoft SQL Server Reporting Services (SSRS) using LINQ and Asp.net
My First Example of using Microsoft SQL Server 2008 Reporting Services (SSRS)Read the article
-
Get month from the datatime column in SQL Server
Get month from the datatime column in SQL ServerRead 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
-
SQL Server Technology Thirst
SQL Server Technology ThirstRead the article
-
Set Vs Select statement in SQL Server
Set Vs Select statement in SQL ServerRead the article
-
Painless management of a logging table in SQL Server
Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for SQL Server. Top 5 hard-earned Lessons of a DBA New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it hereRead 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
-
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
-
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
-
SQL Azure - Creating backups and copies of your databases
As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?Read 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
-
Simplified Restores with SQL Server 2012 Recovery Advisor
Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers. Get smart with SQL Backup ProGet faster, smaller backups with integrated verification.Quickly and easily DBCC CHECKDB your backups. Learn more.Read 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
-
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
-
How To Check Duplicate data in sql
In Sql Hw to check duplicacyRead the article
-
LINQ to SQL Performance Considerations
Performance considerations when using LINQ to SQLRead the article
-
SQL server Interview queries
SQL server Interview queriesRead the article
