Phil Parkin

Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 13,879 total)

RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Tuesday, March 14, 2017 10:36 AM
Thought you might be the one to reply Phil ;). And ha, you don't...

March 14, 2017 at 12:19 pm

#1933114
RE: Are the posted questions getting worse?

drew.allen - Tuesday, March 14, 2017 10:15 AM
I applied for a job yesterday, and they sent me a SQL test to take. I...

March 14, 2017 at 10:25 am

#1933069
RE: More "ACE" driver frustrations. Large Integers loading as exponentials

Thom A - Tuesday, March 14, 2017 9:28 AM
Ok... well I just made a topic and I never appeared, that's really really annoying...
I'm...

March 14, 2017 at 10:21 am

#1933067
RE: Refresh table data from Prod to UAT

SQL!$@w$0ME - Monday, March 13, 2017 10:43 PM
Phil, I don't need a database refresh. Just looking for best options to copy/sync table data...

March 14, 2017 at 5:48 am

#1933010
RE: Refresh table data from Prod to UAT

SQL!$@w$0ME - Monday, March 13, 2017 4:19 PM
Hello Folks,
What is the best approach to refresh UAT table from Production. Tables have foreign...

March 13, 2017 at 5:18 pm

#1932976
RE: SSMS Issues with Intellisense and switching query windows

Here's mine:
I've never even stopped to think about why they quote IE version in this list. I have 11.576 installed.

March 13, 2017 at 4:14 pm

#1932971
RE: SSMS Issues with Intellisense and switching query windows

bartedgerton - Monday, March 13, 2017 3:59 PM
Does anyone else experience constant problems with switching between multiple query windows and having text...

March 13, 2017 at 4:05 pm

#1932966
RE: Excel Import - Truncation Error

ZZartin - Monday, March 13, 2017 1:54 PM
homebrew01 - Monday, March 13, 2017 12:27 PM
A...

March 13, 2017 at 2:23 pm

#1932958
RE: Prevent Loading bad data into Table from excel spreadsheet

komal145 - Monday, March 13, 2017 11:31 AM
Yes, Script task need to validate the excel file columns and if everything is good...

March 13, 2017 at 12:38 pm

#1932944
RE: Excel Import - Truncation Error

Thom A - Monday, March 13, 2017 11:53 AM
It's probably not the destination but the source. ACE is a "wonferful" thing. What length...

March 13, 2017 at 12:28 pm

#1932941
RE: SSIS packages using data transformations in SQL Express edition

momer79 - Monday, March 13, 2017 6:30 AM
Hi,
We have a requirement to import comma separated file into SQL SERVER, new file is...

March 13, 2017 at 7:17 am

#1932873
RE: Need Correct Index for slow query

sqlguy80 - Sunday, March 12, 2017 9:48 AM
Thanks Tom.
That table is used from legacy code.
I will ask them to update the column...

March 12, 2017 at 10:17 am

#1932840
RE: Need Correct Index for slow query

You are selecting all rows in the table, so there is nothing to 'seek' and a scan will always happen.

March 11, 2017 at 9:23 pm

#1932822
RE: Production SSRS Report Issue

Narine M - Friday, March 10, 2017 1:22 PM
Hi All,
Two days back we migrated one database from one server location to another server...

March 10, 2017 at 1:34 pm

#1932791
RE: MS SQL Licensing

lkennedy76 - Friday, March 10, 2017 11:55 AM
If I have a developer reaching over from a SQLDev instance using a linked server into...

March 10, 2017 at 12:11 pm

#1932774

Viewing 15 posts - 5,821 through 5,835 (of 13,879 total)