How To Reduce DOS Attacks
Hello to everyone
I am running MS SQL 2005 Express I get per day 2-4 hackers attacks trying to login from sa?
Some 37 calls times per second one of attack was continuing 4 days
Is there some setting into MS SQL 2005 to reduce that?
Can you recommend me good firewall for DDOS attacks?
Is it there some legal action that I can take to this people I have their IPs most are from US and Canada?
Thank you in advance
val
View Complete Forum Thread with Replies
Related Forum Messages:
DOS Attacks
Dear guys I'm developing a web site that subscribers will directly connect to sql express and send results of their desktop application to database. So every body, including hackers can easily obtain a login. ofcourse I will restrict each login to execute only one stored procedure specially created for himself and do nothing else. (or anotherquery to verify validity of each user, instead of creating special stored procedures for each one) But, I'm worried about frequency of running that stored procedure buy bad users. I can limit frequency of running stored procedure, but anyhow each time of such control also takes time. should I pay attention to such matter? I also don't know what if a user tries to broute force server with incorrect user names and passwords repeatedly. does it lead to slowing down the server? again, should I pay attention to such matter? does firewall help? does IP tarcking help? are these enough? if so, where can I find extra information? In fact this problem persists even if I want to redirect user communications to web service instead of direct connection to data base or even using emails. Anyhow hackers can do the same thing but only some more complexity is added to my project. I found this article for IP tracking in web sites http://weblogs.asp.net/omarzabir/archive/2007/10/16/prevent-denial-of-service-dos-attacks-in-your-web-application.aspx . Is this enough? I wish to know the way big networks do in real world. Can any one please help me? Infact I'm not a professional in security. what ever kind of extra suggestions will be appreciated. regards.
View Replies !
SQL Injection Attacks
Hello, Our Security specialist, is running an audit on one of my systems. All pages pass except the login page. It keeps saying I am getting hit with a SQL injection attack. I filter out special characters, both on the Client Side validation and the server side.It is only the one page I have is failing, and I am beginning to wonder if it is producing false positives.Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogin.Click If Not Page.IsValid Then lblError.Text = "Page Invalid" Exit Sub End If Dim strMesage As String = "" If Not IsInputSanitized(strMesage) Then lblError.Text = strMesage Exit Sub End If If Not ValueIsValid(txtUserName.Value.Trim) Then lblError.Text = Globals.Message_InvalidCharacters Exit Sub End If Public Function IsInputSanitized(ByRef p_strReturnMessage As String) As Boolean Dim loop1 As Integer Dim arr1() As String Dim coll As NameValueCollection Dim regexp As String = "^([^<>" & Chr(34) & "\%;)(&+]*)$" Dim reg As Regex = New Regex(regexp) coll = Request.Form arr1 = coll.AllKeys 'Start at 1 so you will skip over the __VIEWSTATE For loop1 = 0 To UBound(arr1) 'Skip over the ASPNET-generated controls as they will give a false positive. If Left(coll.AllKeys(loop1), 2) <> "__" Then If Not reg.IsMatch(Request(arr1(loop1))) Then p_strReturnMessage = Globals.Message_InvalidCharacters Return False End If End If Next loop1 'If it never hit false retrun true p_strReturnMessage = "Success" Return True End Function If Not ValueIsValid(txtPassword.Value.Trim) Then lblError.Text = Globals.Message_InvalidCharacters Exit Sub End If If Not ValidateUser(txtUserName.Value.Trim, txtPassword.Value.Trim) Then lblError.Text = Globals.Message_LoginInvalid End If End Sub Here are the other validation routines 'This is a check to make sure that the String Values Entered into the Database field 'are indeed valid and without characters that can be used in injection attacks Function ValueIsValid(ByVal p_Input As String) As Boolean Dim strIn As String = p_Input Dim x As Integer Dim A As String Dim l_Return As Boolean = True For x = 1 To Len(strIn) A = Mid(strIn, x, 1) 'Check each character in the string individually If InStr("<>+%|?;()", A) <> 0 Then 'If this is not a "Bad" character l_Return = False 'tack it onto the output string End If Next Return l_Return End Function
View Replies !
SQL Injection Attacks
I am taking a class where the professor really dislikes using parameterized queries because he considers them to be pointless. Despite the many points that I and a classmate bring up, the only thing he considers valid is using them to prevent SQL injection attacks. To prevent this, he replaces all single quotes with a pair of single quotes. I know this works for SQL server, but will fail in some others (for instance MySQL also allows '). Is there other possibilies such as the ' that need to be protected against?
View Replies !
How To Prevent SQL Injection Attacks
Hi, On my site I have a simple textbox which is a keyword search, people type a keyword and then that looks in 3 colums of an SQL database and returns any matches The code is basic i.e. SELECT * FROM Table WHERE Column1 LIKE %searcg% There is no validation of what goes into the text box and I am worried about SQL injection, what can I do to minimize the risk I have just tried the site and put in two single quotes as the search term, this crashed the script so I know I am vunerable. Can anyone help, perhaps point me in the direction of furthur resources on the subject? Thanks Ben
View Replies !
What Are Sql Injection Attacks And How To Prevent?
this is a question I put in the sql community in microsoft, but havent be answered in full ------------ I am using dynamic sql to do a query with differents 'order' sentences and/or 'where' sentences depending on a variable I pass to the sp ex: create proc ex @orden varchar(100) @criterio varchar(100) as declare consulta varchar(4000) set consulta=N'select pais from paises where '+@criterio' order by '+@orden ------------ I'd like to know it it uses 2 sp in the cache, as I read, the main sp and the query inside the variable of the dynamic sql. if so, as I imagine, then I suppose I have to do the main sp without any 'if' sentence to be the same sp, and so taking it from the cache and not recompile the sp now, I have various 'if' sentences in the main sp (the caller of the dynamic sql) but I plan to remove them and do the 'if' by program -it is in asp.net-, so I suppose it is better because in this way the main sp is took from the cache, supposing this uses the cache different that the dynamic sql in the variable what do u think? does the dynamic sql use 2 caches? if so, u think it is better to try to do the main sp same in all uses (no 'if' statements)? ----- They told me this coding is not good (dynamic sql) because it can give control to the user? I ask, how does it give control to use? what ar sql injection attack and how to prevent them? I use dynamis sql because I have 150 queries to do, and thought dynamic sql is good is it true that dynamic sql have to be recompiled in each execution? I suppose so only if the sql variable is different, right? can u help me?
View Replies !
Preventing SQL Injection Attacks
My site has come under attack from sql injections. I thought I hadthings handled by replacing all single quotes with two single quotes,akaReplace(inputString, "'", "''")Alas, clever hackers have still managed to find a way to drop columnsfrom some of my tables. Can anybody direct me towards a best practicedocument on preventing these attacks?Thank you thank you,Kevin
View Replies !
Remote Attacks On My Database
Hi, IĀ“m new on this forum, I just need help to solve or avoid better saying attacks to a SQL Server 2005 database. I Ā“ve had some intruders on my database, changing some data on 2 tables. the information there is too important. But i need to know how can i get all the remote address that make some masive updates on my DB. IĀ“ve make some triggers to avoid that, but those peaoples have reach modify data. I think is some user on the same VPN. Help me please what can i do to get the ip address.
View Replies !
Attempted Brute Force Attacks
It is not uncommon for me to review the event logs of our SQL Server and notice that someone is attempting to figure out the password for one of the SQL user accounts.........especially the "sa" username. But lately our SQL server has to be rebooted to where it is starting to become a nightly thing. Last night the SQL Server was bombarded with attempted failed connections for 2 hours before it finally gave a blank BSOD. The SQL Server in question is in mixed mode and is a shared server. Strictly using Windows Authentication mode is not an option for us. The server has "beefy" hardware and has all updates and patches. Sometimes, when I log on the server and notice that an IP address is making such attacks on the server, I put up an IPSEC policy against that IP. But that is not a good solution for reasons I dont think need to be outlined here. So my question is, what can I do to better protect our SQL Server from these types of attacks? My thought on these attacks is not different than a DDOS that eventually takes the server down. I have already done TCP/IP Hardening but not sure what else to do. Thank you all for your replies.
View Replies !
Injection Attacks Myth Or Fact?
Greetings all, For entertainment purposes, I've been reading some articles on SQL Injection Attacks and there should be a cover charge to read these articles. (excuse the sarcasm) Most defense is based on the use of stored procedures or read only settings on the tables. I'm looking for practical opinions and possibly some code that would convince me personally that this is indeed a real threat. Also, if possible, please post remedies that are solid and not open ended. Thanks all, Adamus
View Replies !
Have 100+ Columns, Or Reduce It Down To About 3?
Basically, what I'm doing is storing answers to questions in a survey. I have two ways I can organize the table: 1. Just having a table with lots of columns - one for each question 2. A table with only about maybe 3 columns: SurveyID QuestionID QuestionAnswer In this second case, the the primary key would be both SurveyID and QuestionID combined, of course. I don't fully know the pros and cons of the two approaches, and both look like they would work. Right now, I'm using option 1, but I keep wondering if option 2 might be better. Whenever I change the questions, I currently have to drop and recreate the table (altering it is too much effort), and I know option 2 would be a way of avoiding that. By the way, the questions themselves are stored in an xml file, if it means anything. Anyhow, once the survey is being used, there shouldn't be any further changing of questions. And there's also just too much I don't know about (how is performance affected, for example?). Any ideas which is better and why?
View Replies !
How To Reduce Db Size?
I need to reduce the size of a db from it's original allocated size of 2.0 gb to 1.0 gb.so that I can allocate more to another db.How can I do?Thanks, Ravi.
View Replies !
Reduce DB Size
I'm new to SQL Server Maintainance. I need some disk space now. In my database, I have some table that has 7 year old data and I can get rid of that without any conequences. Could you please tell me the best course of action ?? I was thinking about: 1. Dropping those tables. 2. Recreating them again 3. Running ShrinkDB on entire DB. However, this solution does not sound right or elegant to me. Could you please help me with that ? Thanks
View Replies !
Best Way To Reduce Deadlocks
I have a search function, which searches across many tables. It's a pretty heavy SPROC, I'm wondering in general, what are the best way to reduce deadlocks ? Its used a fair bit, and altho I haven't noticed problems with it myself, there are definately a decent amount of deadlocks showing up in the logfiles. I've always assumed this is something really difficult, and avoided it like the plague. Any tips are much appreciated ! thanks, mike123
View Replies !
Log File Size Not Reduce
Database log of my DB is around 2GB.The database is using FULL recovery option.I want to reduce the file size of the log cause it takes up a lot ofspace.I'd do a full database backup, then backup the transaction log as well.... both backup performed with a check on the option "clear inactiveentries from transaction log".But after I backup, the database log is still 2GB.What should I do to reduce the database log file size?Should I use?:==============================Dump Tran databaseName with no_logDBCC shrinkdatabase(databaseName, 30)==============================Is that safe to be used in production server?Peter CCH
View Replies !
Reduce Databse Size
Hi, my database size has grown out of control and I need help with thefollowing issues. (I am very new to databases)I am storing financial tick data in one of the tables and after two monthsthe database has grown to 30GB. I do not need a permanent record of thistick data after it has been processed and tried to remove all rows from thistable (delete from Tickdata), however sql does not take kindly to removingmillions of rows and the operation seams to time out. The only solution Icould come up with was to delete the table.Secondly, after managing to clear out these tables I have noticed that thedatabase size is still 30GB, despite 29GB being available. Is there any wayto reduce the size of the database from 30GB. I tried the shrink databaseoption but it does not do anything. Any ideas?Thanks.
View Replies !
HELP! How To Reduce The Unused Spaces ..
HI all, I have a database that allocated: Data: 7300 MB Log: 2000 MB But only used Data: 5500MB Log: 50MB How can I free the unused space in the transaction log because the database is getting too big. Thank you for your suggestion.
View Replies !
How To Reduce The Transaction Log File
Hi all, I know this topic has been discussed in the past, but I still don't quite get it. So please be patient with me database size created with automatically growth of 10% with unrestricted file growth. database size = 5 Gb used 4.5 GB (taskpad) transaction log=8GB used 54MB (taskpad) 7.5 GB free database run in FULL mode full backup nightly, transaction log backup every 30 min What should I do to free up the space that are not used in the transaction log. Thanks for your help.
View Replies !
Reduce Size Of Log Device
Can anyone suggest a method to reduce the size of one our log devices. The DB was set up initially at 500Mb with a log size of 1 Gb (typo by the client). We would like to reduce it to 100Mb. if possible. Our environment is SQL Server 6.5 with service pack 3. thanks,,,brad
View Replies !
Reduce The Size Of Transactional Log
Dear All, I am running Slq2000 (EV) on NT4.0. I have problem is that a size of Transactional Log(*.ldf) file is 3GB. I want to reduced the size to 2GB.Can anyone help me answer this question. Note: I hv already took the backup of Transactional file by choosing Trunct file after backup but size is not got reduced.
View Replies !
How Do I Reduce The Size Of The .LDF File?
I am using SQL 7, SP1 / NT 4. The .LDF file has grown to 1.1GIG; I ran a DBCC SQLPerf(LogSpace), the used portion of the log is 2%. When I run a DBCC Shrinkdatabase and DBCC Shrinkfile, the log file does not reduce in size. How do I get the virtual log files that are not active released back to the system? Is there a way to tell if all the virtual log files are active, therefore, not reducing the size of the file? Any help is greatly appreciated.......
View Replies !
Reduce SQL Server7.0 Database
I'm worhing with SQL Server7.0 and I have created a database. I have objets and data in my database My database have 300Mb and I only need about 50. How can I reduce to 50 the dimension of my database. Is it posible?? Any advice will be greatly apreciatted. Nauj
View Replies !
How To Reduce Transaction Log Size?
My database's transaction log has become 1.7 GB. Can I reduce it's size? I have tried to shrink database and also set truncate on checkpoint option and also taken the backup after that. but nothing helps. Please advice.
View Replies !
Can I Reduce This Sql Statement Syntax?
this is SQL statement in Stored procedure to calculate the last date of a month : (can it reduce to fewer lines??? help!!!!!) argument pass in : @empmt_dt datetime argument return : @last_dt datetime declare @empmt_dt datetime, @mth tinyint, @yr smallint select @empmt_dt = "12/9/2000" select @yr = datepart(year, @empmt_dt) select @mth = datepart(month, @empmt_dt) IF @mth = 12 BEGIN SELECT @mth = 1 SELECT @yr = @yr + 1 END ELSE BEGIN SELECT @mth = @mth + 1 END SELECT dateadd(dd, -1, convert(datetime, STR(@mth,2,0) + '/01/' + STR(@yr,4,0)))
View Replies !
Reduce File Groups
I had a database thats comprised of different file groups and log files spread out among different hard drives. I have recently upgraded the database to SQL 7.0 on a RAID 10 volume. I would like to consolidate all the file groups and files as well as various log files into one primary datafile and logfile. How do I do that? Thanks in advance.
View Replies !
Howto Reduce Tempdb
Hello. Can anybody help me with this? I have a sql server 7.0, where tempdb database has a size of 21 Gb and space available is 2Mb less than 21 Gb. How can I shrink, reduce, compact ... it? I have just tried with Backups and truncate log, but nothing Bye, JuanSa.
View Replies !
How To Reduce The Time When Using A Variable
Hi, I have a table with column value like '123 345 678 143 648' like that. What I need to do is I have to take each code value and put it as a new record in another table. So, if I say 'Select substring(column_name,1,3) from table' then it is very fast (fraction of second). But since I need to take each code and the # of codes in each record may vary, I am using a while loop to take each code and so I delclared a variable @i and now my select statement is like this: 'Select substring(column_name,@i,3) from table'. Interesting now this select statement is taking almost 2 mins for each iteration. Why it is like this? Is there any way I can reduce the time taken to execute each iteration? Thanks.
View Replies !
Help With Query To Reduce Records
I want to write a quick one time query to create a new table based off an existing table. The idea is to make the new table more efficient by reducing the amount of records...see example below id1 id2 country 1 2 US 3 4 AU 5 6 US 7 8 US 9 10 PE 11 12 PE 13 14 US 15 16 US 17 18 US 19 20 US 21 22 US id1 id2 country 1 2 US 3 4 AU 5 8 US 9 12 PE 13 22 US
View Replies !
Shrink Ldf Will Reduce Mdf Size Too?
Hi all; i m using SQL 2000, i have a database with 86G mdf and 56G ldf size. i shrink the ldf and it reduced to 32M, however, i did not do anything on my mdf file, but the size of mdf has been reduced to 28G. just would like to check, is this correct?why is mdf size reduced when i only shrink my ldf? hope can help. thanks
View Replies !
How To Reduce The Size Of Tempdb?
Hi All, On my server C drive is of 34GB. Right now tempdb size is 22GB which is causing C drive to be full. How I can I reduce it? I dont want to move tempdb to any other drive, and I am only looking a way to reduce its size. Please help quickly.... Thanks, Zee
View Replies !
Want To Reduce Execution Time...
Hello all, Mine below function takes much time at every execution. It takes 0.18 sec to retrive 984 rows. Can any one help me, how to reduce execution time? "Create function [dbo].[Fn_Get_Consensus_Curve_41_Data] (@p_Location_Code nvarchar(10), @p_Sector_Id int, @p_Match_Date DateTime ,@p_UserID int , @p_CustId int) RETURNS @Temp_Curve_Submission_Data table ( Location_Codenvarchar(10), Sector_Idint, MatchDatedatetime , EntityIdint , CustomerIdint, MaturityDatedatetime , Cust_Pricefloat , Bid_Pricefloat , Offer_Pricefloat , Consensus_Mid_Price float , Tickernvarchar(20) , Cust_Mnemonicnvarchar(50) , Currency_Idint ) as BEGIN /* GO IF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'Fn_Get_Consensus_Curve_41_Data') AND ((type = 'P') OR (type = 'IF') OR (type = 'TF') OR (type = 'FN')))) DROP FUNCTION [dbo].Fn_Get_Consensus_Curve_41_Data GO */ declare @p_ENTITYID INT declare @p_CUSTOMERID INT Declare @p_Login_Type int Declare @p_Result_Status int set @p_Login_Type = (SELECT DBO.GET_USER_LOGIN_TYPE_ID(@p_UserID)) If @p_Login_Type=1 and not (@p_CustId is null or @p_CustId='') Set @p_Result_Status = 1 Else if @p_Login_Type > 1 Set @p_Result_Status = 2 Else Set @p_Result_Status = 0 If @p_Result_Status > 0 -- if user is valid and given enough parameters than Begin If @p_Result_Status = 1 -- if User is trader and gives customer id Begin Declare Cur_Fetch_Curve_Cust_Data cursor for Select Distinct Customerid From PricesRR PRR Where Convert(Nvarchar,Matchdate,101) = Convert(Nvarchar,@p_Match_Date,101) And Sector_Id = @p_Sector_Id And Location_Code = @p_Location_Code And CustomerID = @p_CustId And --CustomerID <> 0 --CustomerID not in (0, -1, -2, -3, -100, -200) CustomerId Not In (Select CustomerId From Fn_Get_PricesRR_Not_To_Include_Cust_Id('V')) and isnull(PRR.Record_Last_Action,'N') <> 'D' and Version = dbo.GET_PRICESRR_MAX_VERSION(@p_Location_Code, @p_Sector_Id, @p_Match_Date, PRR.EntityID, @p_CustId, PRR.Date) Declare Cur_Fetch_Curve_Entity_Data cursor for Select Distinct EntityID From PricesRR PRR Where Convert(Nvarchar,Matchdate,101) = Convert(Nvarchar,@p_Match_Date,101) And Sector_Id = @p_Sector_Id And Location_Code = @p_Location_Code AND EntityId IN ( Select Distinct Entity_Id from Fn_Get_Allowed_Entity_List(@p_Location_Code , @p_Sector_Id , @p_Match_Date ,@p_UserID )) and isnull(PRR.Record_Last_Action,'N') <> 'D' and Version = dbo.GET_PRICESRR_MAX_VERSION(@p_Location_Code, @p_Sector_Id, @p_Match_Date, PRR.EntityID, @p_CustId, PRR.Date) End Else If @p_Result_Status = 2 -- if User is higher than trader.. means broker or higher Begin Declare Cur_Fetch_Curve_Cust_Data cursor for Select Distinct Customerid From PricesRR PRR Where Convert(Nvarchar,Matchdate,101) = Convert(Nvarchar,@p_Match_Date,101) And Sector_Id = @p_Sector_Id And Location_Code = @p_Location_Code And --CustomerID <> 0 --CustomerID not in (0, -1, -2, -3, -100, -200) CustomerId Not In (Select CustomerId From Fn_Get_PricesRR_Not_To_Include_Cust_Id('V')) and isnull(PRR.Record_Last_Action,'N') <> 'D' --and Version = dbo.GET_PRICESRR_MAX_VERSION(@p_Location_Code, @p_Sector_Id, @p_Match_Date, PRR.EntityID, @p_CustId, PRR.Date) Declare Cur_Fetch_Curve_Entity_Data cursor for Select Distinct EntityID From PricesRR PRR Where Convert(Nvarchar,Matchdate,101) = Convert(Nvarchar,@p_Match_Date,101) And Sector_Id = @p_Sector_Id And Location_Code = @p_Location_Code and isnull(PRR.Record_Last_Action,'N') <> 'D' --and Version = dbo.GET_PRICESRR_MAX_VERSION(@p_Location_Code, @p_Sector_Id, @p_Match_Date, PRR.EntityID, @p_CustId, PRR.Date) End delete from @Temp_Curve_Submission_Data ----------------------- ----------------------- Open Cur_Fetch_Curve_Cust_Data fetch next from Cur_Fetch_Curve_Cust_Data into @p_CUSTOMERID WHILE @@FETCH_STATUS = 0 BEGIN IF @@FETCH_STATUS <> 0 break BEGIN ----------------------- ----------------------- Open Cur_Fetch_Curve_Entity_Data fetch next from Cur_Fetch_Curve_Entity_Data into @p_ENTITYID WHILE @@FETCH_STATUS = 0 BEGIN IF @@FETCH_STATUS <> 0 break ----------------------- Insert Into @Temp_Curve_Submission_Data ( Location_Code , Sector_Id, MatchDate , EntityId , CustomerId , MaturityDate , Cust_Price , Bid_Price, Offer_Price, Consensus_Mid_Price , Ticker , Cust_Mnemonic , Currency_Id ) select @p_Location_CodeLocation_Code, @p_Sector_IdSector_Id, X.MatchDateMatch_Date, X.EntityIdEntity_Id , X.CustomerIdCustomer_Id, X.MaturityDateMaturity_Date, X.PriceCust_Price, X.BidValueBid_Price, X.OfferValueOffer_Price, DBO.GET_Consensus_MID ('V',@p_Location_Code , @p_Sector_Id , @p_Match_Date, @p_ENTITYID ,x.MaturityDate) Consensus_Mid_Price, --DBO.GET_Consensus_MID ('B1',@p_Location_Code , @p_Sector_Id , @p_Match_Date, @p_ENTITYID ,x.MaturityDate) Consensus_Mid_Price, X.TickerTicker , X.MnemonicCust_Mnemonic, X.Currency_Id from ( SELECT row_number() over (order by maturitydate) Line_No, a.* , b.ticker, c.mnemonic from Fn_Get_Tot_Curve_41_Date(@p_Location_Code, @p_Sector_Id, @p_Match_Date, @p_ENTITYID , @p_CUSTOMERID ,@p_UserID ) a, referenceentity b, ( select customerid, mnemonic from customersrr group by customerid,mnemonic ) c where a.customerid = c.customerid and a.EntityID=b.CMAID --order by maturitydate ) X ----------------------- Fetch Next From Cur_Fetch_Curve_Entity_Data Into @p_ENTITYID END CLOSE Cur_Fetch_Curve_Entity_Data END ----------------------- ----------------------- Fetch Next From Cur_Fetch_Curve_Cust_Data Into @p_CUSTOMERID END deallocate Cur_Fetch_Curve_Entity_Data CLOSE Cur_Fetch_Curve_Cust_Data deallocate Cur_Fetch_Curve_Cust_Data End return end " Prashant Hirani
View Replies !
How To Reduce Quantity ? [shopping Cart]
protected void Buy_Click(object sender, EventArgs e) {SqlConnection conn = new SqlConnection(); SqlCommand cmd = new SqlCommand(); try {String connStr = ConfigurationManager.ConnectionStrings["project_DataFile"].ConnectionString; conn.ConnectionString = connStr; conn.Open(); cmd.Connection = conn;ArrayList cart = (ArrayList)Session["Cart"]; {String oldSel = "SELECT Qty_warehouse FROM Producttable"; Int32 sel = 0;Int32.TryParse(oldSel, out sel); string num = cart.Count.ToString();Int32 numQty = 0; Int32.TryParse(num, out numQty);int nQty_warehouse = 0; nQty_warehouse = sel - numQty;String sql = "UPDATE Producttable" + " SET Qty_warehouse =" + "'"+ nQty_warehouse +"'"; cmd.CommandText = sql;} }catch (Exception ex) { Response.Write(ex.ToString()); } finally {if (conn.State.Equals(ConnectionState.Open)) { conn.Close(); Response.Write("end.aspx"); } } from this code, i want to reduce product's quantity in database. when I click buy button,it reduce old quantity and new quantity (quantity from cart when I want to buy it) in auto. please advise me.
View Replies !
Reduce Time For Search Query
Hi,I have a task at hand to reduce the time taken for search query toexecute. The query fetches records which will have to sorted bydegrees away from the logged in user. I have a function whichcalculates the degrees, but using this in the search query slows theexecution and takes about 10 secs to complete which is unacceptable.Please advice. Your help is much appreciatedFor more details plz see:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97021ThanksIsfaar
View Replies !
Reduce Trans Log Size; Help Needed
Hello,I am hoping you can help me with the following problem; I need to processthe following steps every couple of hours in order to keep our Sql 2000database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql serverdatabase and while I have found multiple articles online about the topics Ineed to accomplish, I cannot find any actual examples that explain where Iinput the coded used to accomplish the above-mentioned steps. I dounderstand the theory behind the steps I just do not know how to accomplishthem!If you know of a well-documented tutorial (Aside from Books Online (F1)),please point me in the right direction.Regards.
View Replies !
How To Reduce Database File Size.
We have a database which was created with an initial file size of 10 gig. Currently it is only using 2 gigs. We have developers that want to have a copy of the database on their desktops, but do not have 10 gigs free space. What is the best way to get them a copy of the database while reducing the footprint?
View Replies !
MS SQL 2000- Reduce Transaction Log Size
The size of my transaction log file is out of control. I've backed up the database and the transaction log went from 120 GB to 120 MB. Now, I can't reduce the size of the transaction log file. It's still at 120 GB (w/ almost all of that being held as Free Space). I get errors when I try to manually reduce the file size. Any tips?
View Replies !
How To Reduce Time In Taking BACKUP
Hi guys. I am having trouble in time issues while backuping my database. My database size is around 50GB. It is taking around 5hrs. Is there any way to reduce the 5 hr backup time to 3 or less. Thanks in advance MAK
View Replies !
Reduce The Transaction Log File Size
hi, i'm a newbie in SQL Server and have recently setup a test SQL 7 server. I used all the defaults at the beginning, and now the MDB file is about 500MB and the LDF file is of similar size. i'm still trying to figure out how to reduce the size of the transaction log file. Currently I only have full backup of the database once a week, and there is no backup for transaction log. as of this moment, the transaction log is of not much use to me, but I really want to get it reduced as i'm running out of disk space. and i'd also greatly appreciate if someone could suggest a good DBA practice on the proper setup/handling of transaction logs (how to balance the disk-space usage AND be able to use the transacton logs for proper roll-over during a recovery process). i'd soon be setting up a SQL 7 server where about 10 active users are expected at any one time. I've read that the transaction log file should be about 40% to 50% of the estimated size of the database file, and should be allowed "auto-grow". So what happens if the more space is required by the transaction logs? Does a full-backup purge the transaction logs (like the way they do in Exchange Server)? Thanks!
View Replies !
Reduce Records Shown From Dimension
Hi There, I'm relatively new to AS2005, so you'll have to excuse me if there is a simple solution that has been overlooked. Here is the situation - We have a fact table, linked to several dimensions - one of them being a generic date dimension used by a number of fact tables. The Date Dimension has all dates ranging from 1901 to 2100, but the fact table I am querying just has records from 2005 to present. Once the cube is processed and I open the cube in Excel (for example) it lists every date from the Date Dimension, is there any way to limit which dates are processed into the cube to those that just appear in the fact table (in essence - what would be an Inner Join in TSQL). Hope this makes sense, Regards, Tobias
View Replies !
Using Temporary Tables To Reduce Complexity
Right now I have some code, part SQL, mostly C#, to generate reports from a few tables. I have the following tables: UserGroups -GroupId -UserId Users -UserId -Name ItemLogs -LogId -ItemId -UserId * there will be multiple log entries for each item I'm given a list of GroupIds. I need to retrieve all the users within those groups for each user I need to retrieve the UserId and the Name, along with the number of total rows in the ItemLogs with that user's UserId, and the number of distinct ItemIds in ItemLogs that belong to that User. I'm able to easily do this using C# with minimal SQL, but that involves a lot of looping and small queries which is extremely slow. I'm thinking that I could use some more advance SQL strategies to retrieve what I need a lot faster, but I don't know how. My thought is to first create a temporary table with the group ids I'm given so I can quickly retrieve all of the users I need. Once I have the UserIds, getting the Name is simple, but I don't know how to grab the data I need from ItemLogs without looping through for each User. Any help would be greatly appreciated.
View Replies !
HOW TO REDUCE THE SIZE OF SQL SERVER DATABASE.
I have patch server on which the database is SQL server 2000. The Database size is 27GB and I want to reduce the size of DB by deleting all the records and keeping only year 2007 records. Please advise me how to reduce the size of the DB. If I need to delete any record, please let me know how to delete it. If their is any Query for it, please send the Query. The DB contains total of 11 tables. Thanks to All, Mohammed Muzaffar.
View Replies !
|
TRACKER
