Quick question, is this a SharePoint database?

😎

AFAIK, SQL_Latin1_General_CP1_CI_AS_KS_WS is...

This (Operator Precedence) might be helpful

😎

ankit87 (11/10/2016)

---

Hi experts

i would like to know the realtime replication issues in production servers.generally what kind of issues and solutions will face in the live environment.in future we will...

sqlnewbie17 (11/10/2016)

---

How I do find all the jobs which have failed today and the failed job when they ran the last time they were scheduled.

Ex 1:All jobs if scheduled...

That would be a good start;-)

😎

What you have there is an Object Linking and Embedding (OLE) Compound File (CF)

( Compound...

homebrew01 (11/10/2016)

---

Doesn't cost any money ?? $10,000 to...

homebrew01 (11/10/2016)

---

I'm sure it's a long list, but what are the "Top 10" list of improvements I can take to management to help justify spending the $$ to upgrade ??

We...

Anything in the table that indicates the different file types? There is a great difference between pdf and xls, let alone the difference between...

I understand that using a delete is a business requirement. Do all the tables have a unique clustered index or a single column...

whitesql (11/10/2016)

---

Hi Eirikur,

What if I want to delete the rows of a table per batch like for example I want to delete first 500 records so that it will not...

Jeff Moden (11/10/2016)

---

Eirikur Eiriksson (11/10/2016)

---

Further on the fixed width method, here is an example, 100 x more efficient than XML and roughly 4-8 x more efficient than DelimitedSplit8K.

😎

I have proven...

Further on the fixed width method, here is an example, 100 x more efficient than XML and roughly 4-8 x more efficient than DelimitedSplit8K.

😎

I have proven many times that generic...

Wooosh and no clue

~~~~\o/~~~/\~~~~

😎

21.naved (11/10/2016)

---

I ran dbcc checkdb on all the user db's are no error reported so what should be my next plan of action to find root cause for maint plan...

ramshali83 (11/10/2016)

---

HI SIR,

THANKS FOR REPLY ,

WE ARE USING SAP APPLICATION WITH SQL DATABASE 2005, NOW WE R GOING TO UPGRADE THE DATBASE LEVEL WE HAVE PLAN TO UPGRADE ORACLE...