Viewing 15 posts - 61 through 75 (of 154 total)
sqldba_newbie (2/19/2013)
Steve Thompson-454462 (2/19/2013)
February 19, 2013 at 9:58 am
I'm assuming that total number of pages is a presentation-level metric indicating that at a rate of x records per page, you'll need to link to, and maybe display a...
February 19, 2013 at 8:23 am
mehta.saurabhj (2/8/2013)
what is the difference between assertion and the check constraint as both of them do the same function?Please give an example
mehta.saurabhj (2/8/2013)
I said similar not the same functions!!
mehta.saurabhj (2/8/2013)
February 11, 2013 at 8:05 am
I've been lucky in that I haven't had to be the interviewee in a while, bit I've been the interviewer quite a bit.
My first piece if advice (which is pretty...
February 5, 2013 at 7:45 am
From my experience<*pops*> are often the power supply giving up the ghost; there's not a lot on the motherboard that could make that kind of noise. Problem is, when power...
February 1, 2013 at 7:43 am
pwalter83 (1/31/2013)
Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace...
January 31, 2013 at 9:58 am
pwalter83 (1/31/2013)
However, when I view the result in a browser, it displays all the data from the table in the gridview and doesnt filter out based on the values from...
January 31, 2013 at 8:49 am
AndrewSQLDBA (1/17/2013)
Ok, I have been reading up on Grouping Sets, but I still am not getting it. How would one go about writing a query to work correctly...
January 18, 2013 at 7:53 am
Congrats on the article, Brandie!!!
I'll skip the Tim Leary jokes and get right to my question:
In discussing Isolation, I thought the analogy of the pizza box was clever and appropriate....
January 17, 2013 at 8:07 am
I haven't done this myself, but I've seen discussions about self-managing identities in replicated systems. For example, if you have two offices and want to make sure that identities are...
November 30, 2012 at 8:09 am
Not exactly sure that I follow your requirements, but it sounds like you could use UNION to combine two data sets, one with a GROUP BY and one without. You're...
September 24, 2012 at 7:43 am
patrickmcginnis59 (8/29/2012)
The common situation seems to be that in this case, you don't surround the TABLE COLUMN NAME with date functions.
I believe that that's pretty much what ChrisM said in...
August 29, 2012 at 11:58 am
jdbrown239 (8/27/2012)
I think you guys are right. I have tried writing the view without joins and the result set is never the same. I will look at indexing the tables.
Yeah,...
August 28, 2012 at 8:00 am
Fal (8/24/2012)
August 24, 2012 at 8:05 am
Viewing 15 posts - 61 through 75 (of 154 total)