Hopefully, this is an easy. Does SQL Server use the Windows system date
and time? Or does it keep track of what day/time it is on its own?
We were just discussing this in the office today, because we're
planning for the changes in Daylight Savings Time in the United States
this year. It's going to start a month earlier and end a month later
than it used to. Microsoft is apparently putting out patches for
Windows so the OS will know to adjust the time by an hour on the right
days, and we're trying to determine if our SQL and Oracle databases are
going to be affected at all.
Hi I have a query which executes in 1 second and returning 14 rows whenever I execute it through Management Studio but when I execute it from a web page I am getting a timeout message and the stack trace is pointing towards the line which calls the stored procedure. The query is quite complex and there quite a few joins on tables and views including one to a lookup table, whenever I take out join onto the look up table the web page runs ok without timing out. I join the Lookup table (Parts) using a Left Outer Join similar to below. The syntax of the Join is fine but I cant find why it would cause the query to time out when executed from a webpage but is fine when I execute it from Management Studio select * from tables/view LEFT OUTER JOIN Parts on Parts.PartNumber=tables/View.PartNumber I've tried recompiling the Parts table but it didnt make any difference. Any help would be much appreciated. Cheers, Frankie
I use SQL Server to provide data to asp web pages and have recently started to get ODBC time outs throughout the day.
The environment is as follows: Server with dual PII processors & 512MB RAM running: - SQL Server 7 - IIS
I have a number of asp based web sites hosted on this box, but only 1 of them seems to be affected by the time out problem. I have checked the resources on the server (NT Task Mgr - Memoey & Processor) and everything seems fine - in fact the resources are hardly being touched!!! Within a few minutes the problem disappears completely without me doing anything.
Am I missing something here? Should I look elsewhere other than SQL - maybe IIS ??? Any suggestions / pointers would be very much appreciated.
Some categories have sub-categories. Therefore, some entries will have null for parentID while others will point to another category.
I need to select all of the categories, but have them returned in the correct parent/child order (parents BEFORE children). I can't seem to get this to work correctly. Is this not possible or am I just being stupid?? :)
We are using asp's and tables sucessfully but when we click a link to an exe on a page it is slow, to the point of timing out. Very slow. Any help would be appreciated. Email me tperry@kpmg.com
What could be the reason for my view to timeout? I thought it was because of the number or records, but i guessed wrong. The view is grabbing data from a UDF i have created.
I am trying to use statistics to get the time it takes to run a sql function. When I use SET STATISTICS TIME ON it returns multiple results (one for each insert statement in my loop). Is there any way to get results for the ENTIRE function? Here is the loop that I am timing.--> (It simply populates a calendar table)
SET NOCOUNT ON DECLARE @Counter INT DECLARE @ActualDateDATETIME DECLARE @FirstDateDATETIME SET @Counter = 1 SET @FirstDate = '1/1/1900' SET @ActualDate = @FirstDate WHILE @Counter < 43830 BEGIN INSERT INTO Calendar(ActualDate) values(@ActualDate) SET @ActualDate = DATEADD(day, @Counter, @FirstDate) SET @Counter = @Counter + 1 END
Can anyone tell me as to how I can Timeout a transaction. For example I have transactiopn that pulls in data from a remote source. So if the time of extraction exceeds sometime say 1hr..I need to rollback the transaction.
Cannot use Set Lock_Time out because it can be used only for timing out a waiting process. Here I want to timeout the executing process
I have two tables: 1) Table that holds all available ports. 2) Table that holds users for each port.
There may be times where one user is getting more than one port at a time.
I've built up an ASP .NET page that will display each user its port/s in one table. On another table I want to display all the other available ports which the user doesn't posses and can buy to own.
My problem is where I try to build up the query. I just can't get all the other ports in normal display.
For example, this is what I need:
Ports table: 1/1 1/2 1/3 1/4
Users table: User A , 1/1 User A , 1/2
ASP page display:
------------ User A Holds: 1/1 1/2 ------------
Available: 1/3 1/4 ------------
Of course the Available option is derived from the User Holds query, and just getting the opposit not equal ports, but I just can't get it ! I've tried all kinds of Joins and nesting SELECT queries with no luck.
Hi. I'm new to SQL Server programming. I'm using it at my new job for the first time and catching on quickly. I've run into a problem where I run a request via interactive query and it times out. It's really annoying because it seems to happy a lot. Is this just a memory issue with my machine (it has 2.8 GB of RAM) or there a way around it?
Hi all,i have 97 honda CR-V with about 100,000 KM on it. i checked a doc onHonda web site and it said that 60,000 miles is point to change timingbelt. compared with other Honda cars, it is pretty low. is it correct? ifyes, do you know the reason??thanks for your help,jj
here is my problem and i am probably just stupid. i need the total amount Transfered minus the Received per barcode. so here i would need to see a total of 3.
I wrote a query using the query analizer and tested it before turning it into a Stored Procedure. It worked fine an the execution time was acceptable (25 secs, since there was a lot of data to analize)
When I executed the recently created stored procedure, the execution time happened to be three or four times higher. (1 min, 38 secs)
It was the exact same code, i was logged in the same database server, the parameters were the same in btoh cases. So, my question is as follows:
Why is it that executing a script and executing a stored procedure with the exact same script differ so much in timing?
I've getting the error message at the time ntbackup starts the backup of the server:
Event Type: Error Event Source: SQLWRITER Event Category: None Event ID: 24579 Date: 22-Aug-07 Time: 20:00:26 User: N/A Computer: DBS Description: Sqllib error: Database DYNAMICS of SQL server instance XXX is stored on multiple volumes, only some of which are being shadowed. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 53 51 4c 53 4e 41 50 43 SQLSNAPC 0008: 33 36 31 00 00 00 00 00 361..... 0010: 53 51 4c 53 4e 41 50 43 SQLSNAPC 0018: 32 34 36 00 00 00 00 00 246.....
Where is the problem? How to fix this? Does this mean that I would not be able to restore server in the case of failure?
SQL - version SQL Server 9.0.3054 (2005 SP2) OS - 5.2.3790 (W2k3 R2 SP2)
I am trying to insert form data...three form sections into three different tables....i can insert into one table just fine....is this not possible ...or what? If so can someone please send me a small sample... thank you ...by the way i am using visual studio...vb asp.net 2.0 with ajax. Thanks in advance!
I am creating an index on a table wit 35 million records but I get the error 'TT_ObjPerformance' table- Unable to create index 'IX_TT_ObjPerformance_CACode'. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. How can I get the index created? ThanksSQL Server newbie
I haven't tested it, because at the moment I can't access my SQL database I know this is probably a stupid question, but...How can I test for DBNull when I'm using SqlDataReader.Item(string)? I use to check it using: if(!reader.IsDBNull(2)) ...But I have found that can not count on a particular ordinal reference because some of the stored procedures select the columns in different orders. can I do something like: if(reader["Column1"] != DBNull.Value)or with the reader["Column1"] throw an error because it is not found?? I too hate when people ask questions that they could test themselves...but I can't really test it at the moment. Any input would be greatly appreciated.
I'm trying to backup a database onto a different server within the same SQL Server Group, but the Enterprise Manager only offers the drives on the local server as destination options. Do I have something configured incorrectly or is there a way to do this manually? Thanks in advance.
Ok, I'm trying to understand how the db user corelates to the SqL login. Can one db user have multiple logins attached to it (like dbo with sa and nt admins).
This is in reference to the issue of broken chains of ownership problems that pop up from multiple users creating tables in a single database. I would like to be able to make all the developers be the dbo user of a given database without making them a sysadmin of the entire server. Is this possible?
If not, is there a sp that fixes a db so that all ownership reverts to dbo?
I have a little query in access ..now i must write it in T-Sql
the original... (MSG.IDLINGUA = IIF( EXISTS (SELECT * FROM ESMESSAGGI AS MSG WHERE MSG.IDLINGUA = [@idLingua] AND MSG.IDMESSAGGIO = BITS.IDDESCR), [@idLingua], LDEF.IDLINGUA))
I can't be able to assign a select value at my field... IDLINGUA to perform another select.. Of course I have used the "select case when exists"
I want to run SQL Server 2000 at home, on my PC. I dont have a server. My OS is Windows XP. Is this possible? Or do I have to use something like Access. If so then that sucks.
I use SQL Server at work and I want to practice at home.
