Viewing 15 posts - 421 through 435 (of 1,048 total)
GilaMonster (9/27/2011)
Great for people from the East coast, far from great for anyone coming from Europe (or for that matter just about anywhere outside the USA). Oh well..
Sadly, my company...
September 27, 2011 at 9:04 am
It's not my decision. I've argued for years it should be moved to serve the community. It is coming to Charlotte in 2013, IIRC
Sounds great (only an hour away) see...
September 27, 2011 at 8:47 am
Maybe someday you'll have one these PASS summits on the east coast so I can attend.:cool:
September 27, 2011 at 7:16 am
If the column is not being used by the application and there is no intended future use of that column by the application then yes, by all means drop the...
September 27, 2011 at 7:12 am
I suspect there is a configuration setting within the application or (probably) DB express that is different on some of the clients. Are the clients all using TCP/IP or Named...
September 26, 2011 at 7:31 am
Let the clients determine what they need by passing a parameter to a single stored procedure to obtain their data structures. One of the parameters to the procedure specifies how...
September 26, 2011 at 7:26 am
Maintain an ID value table for obtaining the the next identifier. Obtain the next value from the table and insert into table wrapped in a transaction.
a simplified example:
declare @nextID int
begin...
September 26, 2011 at 7:02 am
Are these clients using ODBC data source to connect to SQL server? I suspect it is a connection configuration issue.
September 26, 2011 at 6:47 am
execute @retCode = [Asset5].[dbo].[RUN_JOB] @JOB_TO_RUN='testjob'
select @retCode
September 23, 2011 at 2:55 pm
Inertia... makes me think of rearranging deck chairs on the Titanic.
September 21, 2011 at 9:29 am
If you need to use SQL server as a platform for your session state management see if you can capitalize on certain of its performance characteristics.
As an example, a page...
September 13, 2011 at 10:46 am
jackimo (9/13/2011)
Attached is the execution plan;Another issue is that no the old session variables are not aged off. The table has 10,000,000 + rows.
Lordy. You should age the...
September 13, 2011 at 10:35 am
If possible, change the clustered index to include both IID and SessionName and drop the non-clustered index on SessionName. Alsop make it a unique clustered index, based on...
September 13, 2011 at 10:19 am
This is an ugly an inefficient way to maintain session state anyway, but the TSQL implementation is very poor also.
To make a long story short, the table is made up...
September 13, 2011 at 9:49 am
Is the insert statement the only statement involved in the transaction? If so, and the query timer times out, the insert will be rolled back.
If other statements are involved the...
September 12, 2011 at 10:33 am
Viewing 15 posts - 421 through 435 (of 1,048 total)