Viewing 15 posts - 1,036 through 1,050 (of 1,409 total)
CleverSQLUserID (6/26/2013)
- obviously produces a different query plan
The query plan is not the indication that your new-style code is false or correct. Your resultset must be the same with...
June 27, 2013 at 1:06 am
The first condition was an easy one: list1 <> list2
To get the other condition was a bit harder. In my solution I combined list1 and list2 together, with the...
June 27, 2013 at 12:43 am
karthik.catchme (6/26/2013)
It was working last month but stopped working this month.
There is most likely something changed in the last month: or in your e-mail list of reciepients, or in the...
June 26, 2013 at 11:59 pm
sweetmoulali (6/26/2013)
TCP Port should be dynamic in cluster environment
This is not correct. In a clustered environment a static IP address is also possible and probably preferrable. Setting up the firewall...
June 26, 2013 at 8:01 am
Is there another job or procedure active that takes additional FULL backups? These backups would brake the transaction log sequence.
Query the [msdb]..[backup%] tables on the primary to get a list...
June 26, 2013 at 7:33 am
Your post is very unclear. How is the 15 (you want to display) related to 1234567890 (the value in the column)?
If you execute: "SELECT 15 as 'ID' "...
June 26, 2013 at 3:34 am
I think it is related to the datatype of the variable. If the columntype is INT the variable must be implicitly converted from the VARCHAR type.
If the value is always...
June 26, 2013 at 2:13 am
If possible, test everything on a specific test (i.e. production acceptance) environment. Copy the (obfuscated) production data to the test environment.
If above is not possible, your current solution works fine....
June 26, 2013 at 1:29 am
Andrew G (6/26/2013)
if you remove the WHERE clause, you're getting a cartisian product or cross join
Of course! You're right... and I will get some coffee to wake up 😉
June 26, 2013 at 1:00 am
Above sample is equal to an INNER JOIN. To get the FULL OUTER JOIN you'll just need to remove the WHERE clause. To get a LEFT (or RIGHT) OUTER JOIN...
June 26, 2013 at 12:30 am
m.rajesh.uk (6/25/2013)
i cant see any service accounts i can see only domain user accounts there. do we need to add service acount in security tab
The user account that is...
June 26, 2013 at 12:14 am
It's unclear which 5 columns you currently select in your query. You could at least mention the columnnames in your post ;-).
Based on your quenstion I guess you can expand...
June 25, 2013 at 2:55 am
You've made a type in the restore command. You have missed the ":" after the drive.
MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'
must be:
MOVE 'MyDBDW_log' TO 'E:\MSSQL\Log\MyDBDW.ldf'
June 25, 2013 at 12:08 am
Your post is a bit difficult to read because you mix up Windows (server) 2008 and SQL Server 2008 at several moments in the text.
If I understand your question correct...
June 24, 2013 at 11:49 pm
Move the "(u.Responsibility = 16 and u.Department = 7 and u.Location = 7)" part to a WHERE clause, just before the GROUP BY. You could also move it to a...
June 24, 2013 at 6:57 am
Viewing 15 posts - 1,036 through 1,050 (of 1,409 total)