Search results for query: *

Anyone know of any problem defragging the shared physical data disk in a 2 node SQL Server cluster? I was thinking just stop the database service on both boxes and then run defrag from one box. Is this the way to do it? Also does anyone have a method for extimating how long something like...

I am suddenly getting timeouts when my app tries to update/insert anything. This is a new problem just started happening today and is currently impacting all 100 desktop users running against a specific instance of the db. No errors occur when the same client app rungs against a copy of the db...

We've got an application which generates letters to clients. I've got a new requirement to "catch" any HIPAA letters going to a non-USA mailing addresses. The standard HIPAA letter is stored in RTF format on a network share, but this letter may be modified at any time. I have a SQLServer...

I want to modify the generic "Page Viewer Web Part" so that it sends some additional properties in the <iframe> tag. Is there a method to do this without re-writing the entire web part? I am trying to add a bit of JavaScript to the iframe onLoad event that will cause the iframe to scroll back...

I am trying to determine the problem in an ASPX that I did not write. In fact, I do not yet have enough skill with ASP.NET to write this page so please go easy on me. If the page were functioning properly, it would allow a user to edit the contents of a greeting letter in rich text format...

I'm looking at a report is supposed to pull data from a query but is raising an error: "Invalid Operation". The main query is itself pulling from 2 subqueries. One of the subqueries prompts the user to enter a date. Running either the main query or the report based off the main query also...

In regular VB, the End statement immediately halts execution. Is there an equivilant statement for VBScript?

What is the syntax for setting inline style of the visited pseudo-class? I mean something like: <a href="#" style="??????">click here</a> What can I put in place of the the red question marks to define the visited style for this one link only?

Is there a CSS keyword that I can use to stop an element from inheriting the CSS of its parent element? Given the example below where one HTML Table nested inside another: <style> .Chart1 { border:1px solid #666666; border-bottom:2px solid #666666; } .Chart1 TD {...

I've always wondered how the database determines the order of rows returned by a SELECT statement when there is no ORDER BY clause. Suppose a table "Animals" with 1 column, and three rows: __CommonName__ Dog Cat Bird Suppose the following SELECT statment: SELECT CommonName FROM Animals The...

Suppose I have a table with some fixed length fields and some variable length fields, and the variable length fields may be null or very long. Does the order of the fields in the table matter? Can I save space by putting all the fixed length fields at the "top" of the column list?

If you have several tables joined together, but only one of them has a limiting condition, is it better to just lay it all out like this: SELECT a.Field1 ,b.Field2 ,c.Field3 ,d.Field4 ,e.Field5 FROM ATable a INNER JOIN BTable b WITH (NOLOCK) ON a.ID = b.aID INNER JOIN...

When I create a temp table inside a stored procedure, it is my habbit to explictly drop it when I'm done... rather than just letting it go out of scope. Is there anything like this I should be doing to table variables?

http://www.eweek.com/article2/0,1895,1943847,00.asp http://msdn.microsoft.com/library/?url=/workshop/author/dhtml/overview/activating_activex.asp

I have a stored procedure that is blocking itself. The code is long but very very simple. It has 20 local variables, each is assigned a different value (count or sum) by a separate simple SELECT query. By simple I mean each uses 4 or fewer tables inner joined NOLOCK. There is no WHERE...

If you are using session variables for your web application's security, remember to clear out all session variables (or just call Session.Abandon) immediately before processing a login attempt. This will help prevent the sort of session hijack attempt mentioned on the following page...

XMLHTTP will be native in IE 7 so you won't need to create the ActiveX object for your AJAX pages... except for backwards compatibility with older browsers.

When starting a reports project in Visual Stuido, is there any way to use one of the Shared Data Sources on the Report Server? Like maybe connect to the Report Server and choose a Shared Data Source that already exists on the server and write your new reports against it? Right now all I know...

Whats up with the little plus sign on related tables? The one where clicking it shows field values from the other table? Is there a way to prevent this from happening?

Suppose I have a business org structure in a table with a compound key made up of all three fields. The data might look like this: Division Branch Office A 1 NY A 2 TX A 2 OK A 2 NM B 1 CA B 1...