Viewing 10 posts - 1 through 10 (of 10 total)
I urge posters to provide complete script from scratch
Without providing table definition and how data is inserted , these kind of posts are highly hypothetical and just academic
Not much use...
March 13, 2020 at 3:36 am
I forgot to mention . This is in SQL 2005 SP2
February 10, 2014 at 3:22 am
Please stop mumbo jumbo wordings. Options could have been with witness / without witness . I hope testing on concept / technical skill and not on english phrases
May 3, 2012 at 5:30 am
Question should be straight forward and clear and should test concepts.
Tricky wording (database files/data files ) should be avoided , which does not make any sense
May 3, 2012 at 4:59 am
When I run on my instance (dynamic port) this gives null . Not much use
Following gives the port
declare @tcpport varchar(1000),@value varchar(250);set @tcpport = 'SOFTWARE\Microsoft\Microsoft SQL Server\' +...
May 24, 2011 at 1:06 am
Practically this is not possible. In production you can not stop and start the service everyday and changes occur to master datbase every day .
February 3, 2011 at 1:51 am
This is a good tool for systeminfo . Do you have a tool to capture sql server information like edition,service pack, cpu affinity mask, memory configured. Now these are...
June 9, 2010 at 11:32 pm
Since the query is referring to the database in SQL Seerver 2000, when I creaetd the query to call sp_db_mail in SQL 2005 through link server , It...
April 3, 2010 at 4:32 am
If you want to send query result using link server approach , you need to create two way link server and provide access to databases in sql 2000 to...
April 2, 2010 at 1:46 am
Since TOP supports a variable , add top variable to select with row_number statement to improve performance
January 4, 2010 at 2:21 am