Search results for query: *

I'm transposing a 2-dimensional Variant array (subtype String) and would like to speed it up using CopyMemory to copy string pointers instead of actually making copies of all the strings. (Of course, if you have a better suggestion, I'm quite open to other ways to accomplish this task.) So...

I am using C# with framework 2.0, but I don't need working code, just some info about the SoapException object returned when using web services to run SSRS reports. If the SQL Server creating the report encounters an error, I do get the exception and can see all sorts of information. However...

In one week I am supposed to come up with the following: Using an existing, working, parameterized SSRS report, 1) Check for work to do. If work is found, go to step 2, otherwise pause for one minute and repeat step 1. 2) Run the report using the two parameters in the work found in step 1...

I tried my first SSIS package today, and it was a very unpleasant experience. I can understand that it takes time to learn something new, but this seems like a joke. Up until the point where I created a package and ran it on my own local computer, things weren't too bad. But trying to deploy it...

I figured out how to do this a month or two ago, and now I can't find it again. Let's say I grant everyone in the Windows Security Group "Department A" general access to a server and to one database on that server. Next, let's also say that I grant another Windows Security Group access to the...

Ever heard of a runaway F5? This is when you intend to highlight only a small section of SQL code but you miss for some reason and when you hit F5, the entire script you have loaded runs instead of just the small part you tried to highlight. It's not enough to put a syntax error at the top of...

While on hold today, I heard "... we value the importance of your call ..." Think about it. Instead of telling your loved ones "you are important to me" just tell them "Your importance is valuable to me!" Of course, you could say this to your enemies, too.

If you want to know how much space is being wasted in a database by using char instead of varchar (or nchar instead of nvarchar), I wrote a full stored procedure for you to do just that which you can get at SQL Waste Land.

For some reason I expected this to work: <style type="text/css"> a:hover span { color:red; } </style> <a href="">some text and <span>a span</span></a> But it didn't work. And I was going to ask a question about it. But in playing with it, I found out something interesting. You can style...

My company, which I'll call California Hospice (the initials are correct) is holding a contest to come up with a creative name other than "Going Green" for a planned environmental friendliness campaign that will run for more than six months. An example of a name they already use is CHIP...

What output will be given by the following query? select len(a), len(b), convert(varchar(10), a), convert(varchar(10), b), ascii(substring(a, 2, 1)), ascii(substring(b, 2, 1)) from ( select a = convert(varbinary(10), convert(varchar(10), 'a')), b = convert(...

I have this somewhat unformed idea about how random javascript code I see in the wild could change for the better. I'm not sure if there's any real performance improvement to be had, but this idea appeals to me really strongly from an elegance and efficiency perspective. And I admit I think it's...

Compete to give the most efficient query that returns a column grouped by key based on the most recent date of another column. I will run your queries against a 359,000 row table I have on a production server. This table records certain information about certain occurrences. CREATE TABLE...

I have a table with 62,037,506 million rows in it, call it BigTable. I am investigating a column, call it SequenceNumber. I just want to see some typical sequences. So I run a query: select top 100 * from BigTable order by ParentID, SequenceNumber This takes forever and I finally kill it...

A while back when I was playing Rollercoaster Tycoon, I got inspired by the roller coaster name "The Vomit Comet" to try to come up with my own euphemisms for throwing up, to name some of my custom-built high-intensity rollercoasters. This thread is for you to share any euphemisms you know...

Since IE doesn't support position:fixed properly, it's difficult to add a title/top bar at the top of the screen but have all the rest of the content on the page scrollable using the main scrollbars. If you have a solution to make IE respect this (ver 6 and up) I'd appreciate it. However, I...

So I have this SQL 2000 server I've granted access to the Windows Group MyDomain\AllUsers. Security access: Grant access Default database: ADatabase Server Roles: <none> Database access: Permit in ADatabase as public role. In ADatabase I have a User: Name: MyApplicationUser Login: MyDomain\All...

I thought I could load multiple projects in VB6 and use code from one project in another. But it appears that's not possible. I can create a project group with multiple projects showing and choose the startup project, but when I try to, say, declare a class variable of a class defined in the...

This started out as a question, but I figured out an answer so here goes. If you have this problem, read down: How does one determine the virtual path for the current application root (or site root if there is no application)? I have a web project that on the test server is an application of...

Is there a way to stuff a two-dimensional variant array into a recordset, basically the opposite of GetRows? Or do I have to do this (pseudocode): Set Rs = New ADODB.Recordset Rs.Fields.Append Name1, Type, Length Rs.Fields.Append Name2, Type, Length Rs.Open For LBound(Array) To UBound(Array)...