Search results for query: *

Hi all, I was wondering if I may bounce a couple ideas off ya'll, I have a project that I am going to implement shortly but before I continue I wanted to know if there would be a more effecate method of storing a retrieving data. The basic thought is: I need to be able to provide a question...

Hello This might be an odd question but... does anyone know if SQL server will crash or mark production database suspect if tempdb goes down? Ok, well here is my issue I have an issue with space on a SAN box. The EDW applications use the tempdb ALOT!! Issue here is we are running out of space...

I have an odd issue (mainly revolving around proper index usage.) For some reason when I use a DATEADD function within a join the between or >= , <= operators the optimizer ignores the index and performs a full table scan. Example This will NOT use the INDEX --code start Select * from...

Hi all, sorry but I think I have to ask a dumb question. I haven't seen any documentation on SQL concerning this issue, yet I have seen some on Oracle. Does column order storage affect performance? Example: If I have a two tables comprised of the same columns (the only difference is the column...

Hi all, I was wondering it anyone has successfully implemented horizontal table partitioning? I have written some simple logic to dynamically create, load and drop the partitioned tables ... which seems to work very well. One thing I have noticed is in development I have defined a date key...

Hi all, I was curious if anyone has heard of SQL server 2000 not optimizing it's self for a star schema. Well... kind of... I have a situation where the optimizer tends to display some odd results in execution plan. It wills attempt to first PULL ALL of the data from the fact table (which is...

Hello all, Now if I understand clustered index correctly, they will store the index in the same order as the data there for speeding up grouping and aggregation. Though one issue that I have seen is during data loads. (In an EDW environment) I have several data load being posted via bulk insert...

Hello all, I have been attempting to create a procedure that will monitor a SQL server for block processes. if found I need it to log specific information about the process ie spid , blocking spid login time ect... but the main thing I need is the one thing that I am having trouble with, and...

Hello all, I was wondering if there was a way to increase the DBCC INPUTBUFFER size, by default it's char(255). Basically I am attempting to write a procedure that will alert me with the spid and executed SQL statement that was executed when a query runs for an extended length of time...

Hello all, This has to be the weirdest thing I have every seen, I have a very simple update routine. The routine update about 18 columns in a fairly large indexed table est.( 86 million and change) up until a few weeks ago the updates ran without a hitch, in fact this same update was tested on a...

Hi all, this is VERY werid, I wrote a sp that has a simple dynamic string builder in it.. that is later exec() the odd thing here is when i attempt to build the SQL string it only returns 307 chars from a varchar(8000) varible. here is the code ( i have stripped out the dyn varibles for ease of...

OK maybe I have been staring at the issue for too long.. Because its HAS to be SIMPLE but I’m just not getting it... The weird this here is when I perform the calculation within a stored procedure or query analyzer it returns a different value verses performing the same calculation in excel or...

Hello all, not too sure if I can do this or not but I have a datalist that i have populated with a series of dates, i also have placed a single textbox in the datalist under the date allowing to enter a value per date. Let’s say 12 days worth or date which can vary depending on a start date and...

Hello, unforntunally i may need to go back to developing in ASP if this continue but i have a form that has 4 dropdown lists on it as well as validation controls. every time i click the submit button and an vaildation is flagged the page reloads and resets ALL of the dropdown list back to the...

Hello all, I have been working on this project off and on for the last couple months and I seem to be missing something here. The project I’m working on lowest level of dimensionally is time hh:mm:ss (well really is a day but... I’ll explain) ------- Think of an employee clocking in to start...

OK, I have beating my head on this for too long now I’m really hoping somebody might shed some light on this issue. I have an existing Citrix farm setup with published applications and web access. Until recently users were able to VPN into our network an access the Citrix resources with no...

Hello all, This is more then likely very simple and I’m just overlooking it. But I have been racking my head on this for a couple of days now, and I haven't been able to come up with a viable solution. I have a start time and an end time with in the same record. Here is the dataset ID starttime...

Hello, I have been working on a File Portal for my companies intranet. currently I can populate the FOLDER and FILE list within a html table but for some reason I can get the datasource to accept multiple dataset. here is my code: as you can see in my code I can populate the DataGrid with...

Hello all, has any one figured out how to control access to folder/file resources using the FileSystemObject properties. I guess when user access a folder share via web they use the IUSR_machine user account. Correct me if am wrong but that would mean that you would only have the ability to set...

Hello, I’m sure I missing something here but i just don't see it...I’m trying to delete a folder using the FileSystemObject property. for some reason it returns an error. ERROR--------- Error Type: Microsoft VBScript runtime (0x800A0034) Bad file name or number...