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...

abhas (11/10/2016)

---

Hi Friends,

Thanks for your suggestion mhtanner and MMartin1 but client want this implementation only.Explained issue but they want like that only. 🙁

Thanks again Eirikur for your help....

andy.plumb (11/10/2016)

---

Hi all

This is my first post here, so hello to you all!

I have a SQL 2008R2 server, which I have created various DTS packages to import data for an...

GilaMonster (11/10/2016)

---

Eirikur Eiriksson (11/10/2016)

---

Yes you can....

Yes you can. Run this command...

Sangeeth878787 (11/10/2016)

---

Hi,

I have a table with date column and primary key column with auto increment, but few times we have been come across these tables not populated with new data...

What is the fill factor for the index?

😎

Henk Schreij (11/10/2016)

---

I wish 🙂

I get the parameters from a outsite source: the people who build the website.

I have some influence...

21.naved (11/9/2016)

---

Executed as user: DAQMSDBS01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started:...

Here is a very simple method that first tries to truncate the table and if that fails, then it deletes all rows from the table.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.AllTables') IS...

Benki Chendu (11/9/2016)

---

He he. I know they are very vast.

But my question is very vague 🙁

If I want to provide some visualizations or dashboards to my customers and want to...

whitesql (11/9/2016)

---

Hi!

I need to delete all tables listed in a table named dbo.tblSum. There are 500 tables that I need to delete.

I am not sure on how to do that...