Hi, I have a table in which there are 100 million rows and 2 supporting table, also have same amount of records. Now, I have created a view to get all related information but it is taking 50-60 mins to querying the data from the view. please advice waht to do so that i can get data in quickly from my...

Hi There I created the test below as a quick check of the servers committed write capability. This scripts runs acceptably fast on my laptop, (which is about 3 year old 7200rpm hard disk, 2.something GHZ pentium processor. 2gb memory. Windows XP 32 bit.) By comparision we have a 64 bit server that is...

Hi, I'm creating a stored procedures of an application that. that will generate some bussiness logic then how can i check performance of stored procedures like speed,accuracy etc. Any ideas or direction will be much appreciated

Hi Everyone, I am wondering if anyone has any tips on either SQL Server configs or MS Server Configs when running your Db's on a Fibre Channel SAN. The Config is, I have 6 servers attached to a FC SAN. Each server has a dual port FC NIC. The servers are attached to both of the 2x FC switches and...

Try http://codegroups.com/blog/index.php/sql-injection-protection/

Code for preventing SQL Injection array_split_item = Array(”–”, “;”, “/*”, “*/”, “@@”, “@”, “char”, “nchar”, “varchar”, “nvarchar”, “alter”, “begin”, “cast”, “create”, “cursor”, “declare”, “delete”, “drop”, “end”, “exec”, “execute”, “fetch”, “insert”, “kill”, “open”, “select”, “sys”, “sysobjects”, “syscolumns...

Hi DBA,s, Now i am going to migrate sql server 2000 to sql server 2005.Just i want to know the bussiness impact which one is best among these. and what are all the commomn issue will face after migrating from sql server 2000 to sql server 2005. Please can any one help on these,.... Thanks, Thulasi R

Hi, Yes you may find that details SQL Log

Hi Subhash, We will need more information to help you, lilke what this job does!! SQL Server sp level!! What exactly the error is!! You need to dig more for the details, see if you have any 1. specific error loged in SQL Error log! 2. refer Job History for that particular job of maintenance plan! 3....

TABLE A BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001 NULL NULL 10005899 en-US 1561001 NULL NULL 10005899 nl-NL 1561001 35023080 NULL 10005899 en-US 1561001 35023080 35023080 10005899 en-US TABLE B BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001...