Search results matching tag 'Database'

SQL SERVER - Find any expression in the database

joggee — Sat, 12 Jul 2008 19:40:29 GMT

My colleagues asked me hundred times, how to find a particular columns, table name, stored procedure, views in the database.

Always forgot to remember one query. So for them only
Below query you can any table, stored procedure or views who ever have that expression as a column or object name...... http://blog.joggee.com/?p=119

CLR data type ,hierarchyid

joggee — Sat, 12 Jul 2008 19:28:31 GMT

The heirarchyid is a system data type available in SQL Server 2008 to represent hierarchies. It is based on a CLR data type, but is always available, whether the CLR is enabled or not...... http://blog.joggee.com/?p=117

Tip of the day

joggee — Sat, 12 Jul 2008 19:16:38 GMT

In SQL Server 2008, which index hint will ensure that in index seek operation is used?......... http://blog.joggee.com/?p=116

Avoiding five Most Common SEO Mistakes

joggee — Sat, 12 Jul 2008 19:04:35 GMT

I know this is not a good impact to copy and paste in your blog. But this was a wonderful article and I just copied and paste here to share with my all fellows/reader. My motive is to share the things.....
http://blog.joggee.com/?p=115

Tip of the day

joggee — Sat, 12 Jul 2008 19:00:05 GMT

Identify Duplicate Values in an Excel Table
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.... http://blog.joggee.com/?p=114

Tip of the day ,Find the Correct Format for Excel Formulas

joggee — Sat, 12 Jul 2008 18:51:04 GMT

Find the Correct Format for Excel Formulas
You can use Microsoft IntelliSense technology in Microsoft Office Excel 2007 to create formulas. If you want to type a formula in Excel 2007....... http://blog.joggee.com/?p=113

Fulltext Searching,Fulltext Indexing, Installing Microsoft Search Service

joggee — Sat, 12 Jul 2008 18:46:03 GMT

I received some emails from several groups, people were asking about the fulltext search, so I decided to write about fulltext indexing. I had consolidated a lot of information in one article and these includes Installation of fulltext,MSSearch Services and Noisy words which should be eliminated before searching....... http://blog.joggee.com/?p=112

How to stop debugger in asp.net?

joggee — Sat, 12 Jul 2008 18:36:20 GMT

You can stop debugger in asp.net using below code.

(VB.Net)........ http://blog.joggee.com/?p=111

What is XML-RPC

joggee — Sat, 12 Jul 2008 18:30:45 GMT

It's a spec and a set of implementations that allow software running on disparate operating systems, running in different environments to make procedure calls over the Internet...... http://blog.joggee.com/?p=110

Migrate to SQL Server (SSMA)

joggee — Sat, 12 Jul 2008 18:27:31 GMT

If you wanted to migrate data from Access, Oracle and Sybase to SQL SERVER 2005.
http://blog.joggee.com/?p=101