iPhone Interview Questions 2
1)what happens if you remove the object from the array, and you try to use it?our application crashes 2)Difference between HTML & XML? XML was designed to transfer and store the data XML was to carry data not to display the data XML is designed to be…
iphone interview questions
1. Explain what ARC is and how it works Since it doesn’t make much sense to talk about the old retain-release cycle, instead I like to find out if the candidate actually knows what ARC really is, or if they just consider a bit of Apple magic. ARC stands…
DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement
DELETE From SELECT Statement It is totally possible to use JOIN and multiple tables in the DELETE statement. Let us use the same table structure which we had used previously. Let us see the following example. We have two tables Table 1 and Table 2. --…
Reasons for Statement Recompilation
What is recompilation in SQL Server? Recompilation is the same process as a compilation, just executed again. If the database structure or data changes significantly, a recompilation is required to create a new query execution plan that will be optimal…
SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP
Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azure it became trivial. Here’s what you basically need to do: Once SQLBackupAndFTP with Azure is installed, click at “Connect to SQL Server /…
RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds
Identity Column in Database Syntax DBCC CHECKIDENT ( table_name [, { NORESEED | { RESEED [, new_reseed_value ] } } ] ) [ WITH NO_INFOMSGS ] table_name Is the name of the table for which to check the current identity value. The table specified must…
Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards
CONCAT_NULL_YIELDS_NULL will be always ON in the future so avoid setting it off. What this function essentially does is that when it is on it will return a null value when any other value is connected it with using + operator.…
Adding Column Defaulting to Current Datetime in Table
Let us see our solution. Let us first create a table which does not have column with current datetime. In our case we will assume that there are only two rows in the table. USE tempdb GO -- Create Table CREATE TABLE TestTable (ID INT, Col1 VARCHAR(100));…
A New Approach to Scale .NET Applications
A typical scale-out architecture might look like this: Each process in the NuoDB architecture represents a virtual or physical cloud resource but the database as a whole continues to represent itself as a single logical database to any client that’s…
SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters
Just quick to summarize the puzzle. Here is the quick recap of the same. Now let us run following script. DECLARE @FirstString VARCHAR(MAX) DECLARE @SecondString VARCHAR(MAX) DECLARE @ThirdString VARCHAR(MAX) SET @FirstString = REPLICATE('A',4000) SELECT…