|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Audit log huge reads Posted by Flomo Togba Kwele at 7/14/2007 5:09:25 PM Im a newbie. I have read many posts similar to this one, but I think this one is unlike others.
I run the profiler and see that there is an Audit Logout event class with no TextData description.
The exec step usually is 4-20 reads.
But the Audit Logout step takes around 5 million reads and 3....more >>
procedure that returns a dataset? how can I test it? Posted by jobs at 7/14/2007 1:44:17 PM Really Dumb question.
I have this simple procedure that will return a dataset to my asp.net/
vb.net application. I've done this before.
How can i test it from sql server 2005? I know rows qualify, but the
default execute procedure only returns 0.
And apparently, I can't do this: select ...more >>
sql server statistics Posted by Henry at 7/14/2007 1:09:39 PM Is there a procedure that can report the statistics for last time a specific
table is accessed, or a running list of tables access and time etc. ?
Thanks for Info
Henry
--
~
Most good judgment comes from experience.
Most experience comes from bad judgm...more >>
sp_prepare/sp_execute vs Stored procedures Posted by Hassan at 7/14/2007 12:56:49 PM Our applications invoke SQL using sp_prepare and sp_execute( as to what I
see in Profiler) and we do not use stored procedures.
Can you give me pros and cons of the 2 approaches ? We are using SQL 2000.
...more >>
database backup Posted by rodchar at 7/14/2007 10:18:03 AM hey all,
if i have just msde on a machine is it possible to database backups on it?
thanks,
rodchar...more >>
creating a stored procedure to create a table Posted by jorge at 7/14/2007 1:42:12 AM I'm a bit of an SQL novice: I'm trying to create a stored procedure
to
create tables. This seems to work fine as long as the table name is
not a variable. However, I want to execute the stored procedure
passing in the name of the table as a parameter. However, I get
errors
when trying to creat...more >>
Delete Duplicates, Keep Foreign Key References, and Combine Records Posted by rh1200la NO[at]SPAM gmail.com at 7/14/2007 12:46:53 AM Hey all, I'm having a bit of a problem ever since our company upgraded
their message board system.
During the import the users table has created many duplicate entries.
There are no duplicate user id's (primary key) as they are the
identity values, but there are obvious duplicates on the usern...more >>
Simulating the Sql-99 OLAP window for cumulative sums in S2005 Posted by Steve Dassin at 7/14/2007 12:30:43 AM This is a Dataphor/Sql Server 2005 'demo' based on the concept of the
ansi Sql-99 OLAP window for cumulative sums.
Dataphor - An example of rapid application development
http://beyondsql.blogspot.com/2007/07/dataphor-example-of-rapid-application.html
The setup scripts can be downloaded here. T...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2005: How to set a fast cursor? Faster than FAST_FORWARD? Posted by Andreas Klemt at 7/14/2007 12:00:00 AM Hello,
how must a set a cursor in SQL 2005 to be faster then this:
DECLARE cur CURSOR FAST_FORWARD FOR
I mean there are so many options like READ_ONLY etc.
I just need the cursor to loop through some records.
Thanks for any help in advance!
Andreas...more >>
HELP: CLR Trigger Fails when inside a user defined transaction! Posted by Leon_Amirreza at 7/14/2007 12:00:00 AM when I use my C# Application to update My DB using a transation I get the
following Exception
The context transaction which was active before entering user defined
routine, trigger or aggregate "UpdateIntegrityCheck" has been ended inside
of it, which is not allowed. Change application logic...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |