Viewing 15 posts - 481 through 495 (of 1,069 total)
In my openion, it is a good idea to use temp table instead of permanent table to avoid deadlock issue.
Make sure that the tempdb has enough number of data files...
July 20, 2011 at 4:13 am
I agree 100% with Stunner.
I have faced this issue many times.
Once I told my collegue about this and asked him what should I do.
He adviced me to give the...
July 18, 2011 at 4:07 am
opc.three (6/25/2011)
Why in the world would you ever want to even attempt that?
May be he has setup Log Shipping...
July 18, 2011 at 2:49 am
Write to script to recreate the clustered index in the filegroup.
July 18, 2011 at 2:35 am
Check the job history to see the exact reason for job failure.
I guess there is some permission related issue.
July 18, 2011 at 2:21 am
Execution plan is created by the database engine. You need suitable permision excute the query. Then only execution plan gets created.
July 18, 2011 at 2:06 am
You can use REPLACE twice...
SELECT REPLACE(REPLACE(Body, '{{T}}', Col1), '{{K}}', Col2) FROM Table1
July 18, 2011 at 1:57 am
ringovski (7/17/2011)
1.Current: June 29 2011 12:00 AM
Expected: dd/mm/yyyy(no seconds)
Code: CASE WHEN RowId = 1 THEN CAST(IssueDate AS VARCHAR(20))
ELSE ''
SELECT...
July 18, 2011 at 1:46 am
shanghaigirl-1125377 (7/16/2011)
July 18, 2011 at 1:35 am
I do not have any idea about the upgrade path.
It is possible to directly go to SQL Server 2008 exams.
Note: Earlier (during SQL Server 2000) it was known as...
July 17, 2011 at 11:54 pm
It is database design issue. Not RDBMS issue.
I think no RDBMS (Oracle, SQL Server, MySQL, etc.) forces you to have PK.
I think forcing PK is against database design principle.
(Others may...
July 15, 2011 at 5:08 am
This works:
select * from [Server\UAT3].master.dbo.syslogins
This also works:
select * from [Server\UAT3].master.sys.syslogins
July 15, 2011 at 5:01 am
If lack of primary/unique key constraint caused duplicate rows in your table,
you can delete the duplicate rows now and add a primary/unique key constraints to your existing table to fix...
July 15, 2011 at 4:54 am
Why not?
What are the issues faced becuase of this?
Why do you think SQL Server should force you to have a primary key?
July 15, 2011 at 4:26 am
You are right. Replication is not possible if the servers are not connected.
Differential/Log backup is ideal for your scenario.
July 15, 2011 at 2:23 am
Viewing 15 posts - 481 through 495 (of 1,069 total)