Whats New in SQL Server Denali : TRY_CONVERT(), a Good Addition (connectsql.blogspot.com)

submitted by lionofdezert(1110) 9 months, 17 days ago

While working with different type of data, I have not found a single day, without data type conversion error. Sometime error could be just because of a single row, out of million of correct rows.To avoid such error, with out writing long quires, SQL Server Denali has introduced a new function TRY_CONVERT(). read more...

add a comment |category: Database |Views: 2

tags: Database another

Whats New in SQL Server Denali: Format(), a Most Wanted Function(connectsql.blogspot.com)

submitted by lionofdezert(1110) 9 months, 20 days ago

Most of SQL Server developers/DBAs think that converting DateTime to a specific format is bit difficult as you need to remember specific format number, which you can use with CONVERT(). But now using SQL Server Denali, you can use a most demanded function FORMAT(). read more...

add a comment |category: Database |Views: 2

tags: Database another

What’s New in SQL Server Denali: Get Date/Time from Parts(connectsql.blogspot.com)

submitted by lionofdezert(1110) 9 months, 22 days ago

SQL Server Denali has made developers life quite easy by introducing new useful functions. DATEFROMPARTS()is a new function introduced in SQL Server Denali CTP3,which will help us to avoid lengthy code to get date from year, month and day inputs. read more...

add a comment |category: Database |Views: 2

tags: Database another

Whats New in SQL Server Denali: EOMONTH() function to Get Last Date of(connectsql.blogspot.com)

submitted by lionofdezert(1110) 9 months, 24 days ago

EOMONTH() is a new function introduced in SQL Server Denali CTP3. Purpose of this function is to avoid lengthy tsql code to get last day of any given month. read more...

1 comment |category: Database |Views: 12

tags: Database another

Whats New in SQL Server Denali: IIF Logical Function (connectsql.blogspot.com)

submitted by lionofdezert(1110) 9 months, 25 days ago

If you have developed some sort of applications using Microsoft Access, then you are definitely familiar with “IIF” logical function.In SQL Server, prior to SQL Server Denali we can use “CASE” instead of “IIF” as this logical function was not available. But in SQL Server Denali CTP3, “IIF” is available with same ease and functionality. read more...

add a comment |category: Database |Views: 10

tags: Database another

SQL Server Denali: CTP3 Insallation Error "The Data is invalid" (connectsql.blogspot.com)

submitted by lionofdezert(1110) 9 months, 26 days ago

During extracting files from SQLFULL_x86_ENU_Core.box, SQL Server Denali CTP3 produce an error "The Data is invalid". But unfortunately there is no information provided by Microsoft itself to resolve this error. read more...

add a comment |category: Database |Views: 4

tags: Database another

SQL SERVER: Extract Data from OpenEdge Progress without OLE DB Driver(connectsql.blogspot.com)

submitted by lionofdezert(1110) 10 months, 2 days ago

Importing data from OpenEdge’s Progress® data base is simple if you have OLE DB data provider. But if you don’t have OLE DB driver or unable to configure it properly then there are few simple steps to migrate data from OpenEdge’s Progress® to SQL Server. read more...

add a comment |category: Database |Views: 6

tags: Database another

SQL Server: How to Import Data from Sybase Advantage (adt Files)(connectsql.blogspot.com)

submitted by lionofdezert(1110) 10 months, 9 days ago

As compared to other RDBMS, to import data from Sybase Advantage to SQL Server is bit tricky because first you must free target “adt” files from its database dictionary. read more...

add a comment |category: Database |Views: 14

tags: Database another

SQL Server: Where to Find Saved Import/Export SSIS Packages(connectsql.blogspot.com)

submitted by lionofdezert(1110) 10 months, 29 days ago

Using SQL Server Import Export Utility, have you ever saved this SSIS package to SQL Server ? Where he can find this saved package to re-execute it. read more...

add a comment |category: Database |Views: 3

tags: Database another

SQL Serve Videos: Installing SQL Server and Creating Your First Databa(connectsql.blogspot.com)

submitted by lionofdezert(1110) 11 months, 7 days ago

If it’s your first day with SQL Server and you need someone who can help you in installation and creation of your first database in SQL Server, then following very helpful videos at youtube are uploaded for you. read more...

add a comment |category: Database |Views: 10

tags: Database another

SQL Server: Quickest Method to Create Single Table Backup(connectsql.com)

submitted by lionofdezert(1110) 11 months, 18 days ago

Well, what is more quick and simplest way to create a single table backup, a csv file with export wizard, data code generator, bcp or something more simple and quick. read more...

add a comment |category: Database |Views: 20

tags: Database another

SQL Server: Does Unwanted Tables in a Query or View Affect Performance(connectsql.com)

submitted by lionofdezert(1110) 11 months, 19 days ago

is it true that presence of extra tables in joins section of a query, will affect query performance. Extra tables means, tables which can be skipped from query without affecting query result read more...

add a comment |category: Database |Views: 19

tags: Database another

SQL Server: Automatic Query Execution at Every Instance Startup (connectsql.blogspot.com)

submitted by lionofdezert(1110) 11 months, 23 days ago

Do you have some queries (audit or any other) which should be executed on every instance restart and you need to execute these queries automatically. If yes there is a simple method to achieve this task. read more...

add a comment |category: Database |Views: 6

tags: Database another

SQL Server: Date Change Capture without Using Trigger (connectsql.blogspot.com)

submitted by lionofdezert(1110) 11 months, 24 days ago

Most of SQL Server users think that trigger is the only place where we can use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement. Simple insert,update or insert queries can be modified to capture change data. read more...

add a comment |category: Database |Views: 16

tags: Database another

SQL Server: What I Have Learned in May 2011 (connectsql.blogspot.com)

submitted by lionofdezert(1110) 11 months, 25 days ago

What i have learned and shared about SQL Server during month of May 2011 read more...

add a comment |category: Database |Views: 19

tags: Database another

SQL Server: How to Analyze Ad Hoc Queries Workload(blogs.dotnetkicks.com)

submitted by lionofdezert(1110) 11 months, 29 days ago

Lets figure out work pressure of Ad Hoc queries. read more...

add a comment |category: Database |Views: 8

tags: Database another