Viewing 15 topics - 270,001 through 270,015 (of 283,946 total)
Topics
Started by
Posts
Last post
Hello all! One thing that is easy to note as you follow SQLServerCentral.com for a while is that al…
5 replies
Hi all- I have a situation where I need to get the system datetime from within a UDF. And I get an…
3 replies
I'm running into major performance problems with the following statement: UPDATE [WebDB].dbo.ACL S…
8 replies
Hi, I am running SQL server 2000 Enterprise Ed. We have a database designed buy a third party which…
3 replies
Hello all, Is there a way to identify Junction tables in a database using T-SQL? -Isaiah
4 replies
I have a select query that gives inconsistent result sets that is based on tables with static data.…
13 replies
I have a session table: CREATE TABLE [dbo].[session] ( [session_id][char](32) NOT NULL , [data][tex…
2 replies
I want to find whether the given (Server name as input )SQL Server is active or not using T-SQL.
2 replies
I need some help with getting a point in time restore to work successfully. I need to restore my d…
13 replies
When SQL Server evaluates (in a WHERE clause) something like: "TeamID IS NULL OR TeamID = @ID" ...a…
14 replies
In a stored procedure report, how do I allow an optional filter for a select statement/ For example…
24 replies
Does each file in a filegroup open a new thread for r/w or does the fact that multiple files in a f…
4 replies
If at the beginning of a Stored Procedure I put the line SET DATEFORMAT dmy does the dateformat cha…
1 replies
Hello Everyone, I wish to insert name, dob, and ss number into a persons table in a customers datab…
1 replies
As a general rule is there any performance gain in the order I list my tables in the FROM clause? e…
8 replies
Viewing 15 topics - 270,001 through 270,015 (of 283,946 total)