Topics
Started by
Posts
Last post
SET NOCOUNT ON; Exec sp_MSforeachdb 'USE ? DECLARE @objectid int; DECLARE @indexid int; DECLARE @pa…
2 replies
hi SQL family, which statement regarding maxdop is true as I am slightly confused... 1)MAXDOP limit…
1 replies
Hi, appreciate it very much if you can guide me, I have a table below where I want to calculate the…
24 replies
I have a job with a DTS that gets data from a DB2 DB to SQL, when i run the job in my pc it runs pe…
1 replies
Hi experts, I hope someone help me on how can i make my SQL script faster. Here is a background on …
18 replies
I am getting a following error while running a very basic query: Msg 1205, Level 13, State 2, Line …
6 replies
I am running server-side trace to catch a certain stored procedure and its parameter values. I am t…
20 replies
I have an SSIS package that is connecting to a database using an ODBC connection. The connection i…
1 replies
Hi Group! I am trying to calculate the number of days between 2 given dates - received date and det…
7 replies
I'm wondering if anyone has come across something like this. I've got a SQL 2008R2 Std database wit…
1 replies
Hello, Is this Ok if the SQL Server Agent service account uses NTLM rather using Kerberos? Note: S…
1 replies
Hello Experts Willing to know if there can be any impact if a full database backup and tlog backup …
6 replies
Hello Is there any valid reason for such alert? Note: we don't have any such login account in SQL S…
2 replies
Last week a T-SQL batch suddenly took an incredibly longer time to complete, after a deep analysis …
27 replies
SELECT T. Col1, T.col2 FROM TABLE T WHERE 1 = 1 There is a space after T. and before Col1 without t…
6 replies
Viewing 15 topics - 2,836 through 2,850 (of 30,222 total)
You must be logged in to create new topics.