Viewing 15 posts - 7,111 through 7,125 (of 7,165 total)
Sounds like a proprietary SEQUENCE to me. Can you refactor?
Your proprietary sequence (you called it ID) had to start somewhere so you must have a seed. Since all proprietary "ID"s...
February 24, 2011 at 10:12 am
In short, yes.
Try this:
SELECT CONVERT(DATETIME,'15 Feb 2011 12 am',121) as my_date ;
February 23, 2011 at 4:02 pm
Are you asking about a scenario when moving data between two tables on different instances?
I'll assume yes.
BULK INSERT will not do this but OPENROWSET or OPENQUERY using a Linked Server...
February 23, 2011 at 3:19 pm
My first thought was to use the SSIS object model in C# to execute the package and then attach to events that would allow you to end a process early...
February 23, 2011 at 1:54 pm
What is the value of the package property "ProtectionLevel"? You can find this by right clicking some open area on the Control Flow design area and choosing properties.
February 23, 2011 at 1:45 pm
Chances are you're trying to read a Unicode file as ANSI or the end of line character in your file connection in SSIS (e.g. {CR}{LF} ) is different from the...
February 23, 2011 at 1:24 pm
Kevin Dahl (2/22/2011)
February 22, 2011 at 3:24 pm
Lutz has a point...dynamically generating a crosstab query would require approximately the same level of effort from you and would almost certainly perform better than a PIVOT. My code example...
February 22, 2011 at 3:20 pm
As with most things...it depends. Performance absolutely CAN be affected by sharing a SAN across multiple SQL instances. There are many different types of SANs...some allow you to isolate your...
February 22, 2011 at 2:51 pm
Building a PIVOT query dynamically is a viable option. Using your DDL I created a simple PIVOT query:
SELECT pvt.RecordID,
pvt.Variable1,
...
February 22, 2011 at 2:31 pm
Nope...the [Server Name] column appears to be appended by the IDE, not on the server-side.
February 22, 2011 at 1:35 pm
You said are going to put all the proc executions into SQL Server Agent Jobs so I would recommend looking into the logging functionality available within SQL Server Agent. Within...
February 22, 2011 at 12:10 pm
There are ways to "tune" Linked Server queries by deciding between accessing remote data using either 4-part naming or OPENROWSET OPENQUERY. As Craig mentioned depending on how your query is...
February 17, 2011 at 3:59 pm
If SQL 2005 or above you should look at using EXECUTE AS. You can create a stored proc that can create logins as needed as if a sysadmin was doing...
February 17, 2011 at 1:39 pm
What does your requirement say if the day passed is between the third Saturday of the month and the last day of the month?
Ooops, misread your comment "current day passed...
February 17, 2011 at 1:13 pm
Viewing 15 posts - 7,111 through 7,125 (of 7,165 total)