Viewing 15 posts - 1,441 through 1,455 (of 1,479 total)
a2zwd (10/6/2008)
I am writing a query to display records from a table between 2 dates.
When I write the query with static dates, its executing in 1 second....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 6, 2008 at 6:26 am
arjun.tewari (10/6/2008)
Does any body have any idea about the below error:
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 6, 2008 at 4:21 am
Niyala (10/6/2008)
I got the following message which is related to SQL Server. I was wondering if anyone could explain to me what they mean?
DBSPI-3266.1: # of transaction log expansions...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 6, 2008 at 3:31 am
jeremiah.peschka (10/3/2008)
That is, is:
CREATE TABLE User (
UserId INT IDENTITY(1,1) PRIMARY KEY,
UserTypeId INT REFERENCES UserType(UserTypeId),
-- 50 columns
);
any faster to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 3, 2008 at 12:59 pm
Jeff Moden (10/3/2008)
Sam... please read and heed the article at the link in my signature. I'm pretty...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 3, 2008 at 9:34 am
samsql (10/3/2008)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 3, 2008 at 3:35 am
samsql (9/30/2008)
CREATE TABLE dbo.table2
(
...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 3, 2008 at 1:55 am
Jim Russell (10/2/2008)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 2, 2008 at 12:55 pm
Jane (10/1/2008)
A BIG 'Name and Shame' poster in the common area works well...two strikes and you're named. Actually, this works for lots of things. 😉
I wouldn’t set rowcount...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 2, 2008 at 2:59 am
samsql (9/30/2008)
Hi i want make a query such like there is a there is a 3 not null value between column img1 to img10 the query shud give me...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 30, 2008 at 11:09 pm
tt (9/29/2008)
I just want to be notified when the table has 400 rows inserted.Thank you.
Any reason that you refuse to answer the questions that asked you? In any case...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 29, 2008 at 5:03 am
tt (9/29/2008)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 29, 2008 at 4:43 am
If you are using Managemant studio, you can just type GO 20 after the insert statement:
INSERT INTO #test DEFAULT VALUES
go 20
This will cause the insert statement to run 20...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 29, 2008 at 3:45 am
MV (9/26/2008)
Hi,I have checked and AutoShrink = False.
If the log file isn’t set to auto shrink, then someone is shrinking it. Check it you have a job that shrinks...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 26, 2008 at 2:13 am
I think that today’s question wasn’t a good one. Since the answer is number of 8KB pages there was no correct choice given to us. Bytes much more...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 25, 2008 at 9:30 am
Viewing 15 posts - 1,441 through 1,455 (of 1,479 total)