LutzM

Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 5,502 total)

RE: convert MS SQL database to MySQL

If you "just" want to copy data, I would recommend to use bcp and generate files. Then use some MySQL tools to get the data back in (those tools exist,...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 8:14 am

#1372600
RE: Automatic XML

Any chance to post a sample or two and your expected output?
You could also drop me a PM / email if you like.
The data type issue is definitely something a...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 7:58 am

#1372585
RE: Has the culture of this web site changed?

I try to differentiate between the people posting for a hint or advice because they're stuck and the ones with the attitude of "Do my (paid) job! Now!".
Once in a...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 5:55 am

#1372490
RE: PowerPivot

You might want to ask this question in a PowerPivot forum.
From my point of view SQL Server only serves as a data provider.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 5:31 am

#1372479
RE: Identifier Consistency Across Environments

Let's assume the ToolID is the identity column of a Tools table. Then there also should be a description or name.
Instead of using the db internal ToolID directly, I would...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 4:48 am

#1372458
RE: Automatic XML

R.P.Rozema (8/24/2011)
Attributes can be found using @*. So the names of these attributes can be found like this:
declare @xml xml;
select @xml = N'
<root>
<node attr1="1" attr2="2"/>
...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 4:41 am

#1372456
RE: Count Number of rows added within a certain time period

In order to know the daet range we'll need a start date.
The end date can either be limited by the number of rows, an additional date parameter or by limiting...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 4:26 am

#1372449
RE: Automatic XML

Jeff,
here are some additional sources you might want to have a look at:
Peso@SSC -> a similar approach like the one R.P.Rozema suggested and
Jason Follas blog. Jasons approach is based on...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 24, 2011 at 12:11 am

#1372359
RE: Better Query instead of loop

uciltas-924976 (8/23/2011)
I am getting an error.
Msg 102, Level 15, State 1, Line 36
Incorrect syntax near ')'.
The syntax seems to be correct
Without seeing the query it's hard to tell.
I think there's...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 23, 2011 at 8:17 am

#1372031
RE: Combining results into one data row

Please have a look at the CrossTab article referenced in my signature. It's most probably exactly what you're looking for.
As a side note: If you know the data of each...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 22, 2011 at 7:45 am

#1371409
RE: Query execution time between "IN" operator and "Inner Join"

As long as you're not allowed to index this column, almost every approach will take a significant amount of time since you'll need to perform a table scan (or clustered...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 22, 2011 at 7:13 am

#1371388
RE: Consider these this two DBA position

I just had a glance at the first one. The job description sounds like asking for a complete dev team including the backbone DBA staff. Not to forget the customer...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 21, 2011 at 8:52 am

#1371167
RE: How to view a tables relations.

What do you define as "being referenced"?
If you'ro looking for the refernces assigned by using foreign keys, you could look at sys.foreign_key_columns.
Other than that you'd need to analyze each object...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 21, 2011 at 8:26 am

#1371160
RE: Database fails to come online after restore... somewhat urgent.

NJ-DBA (8/21/2011)
yeah, was a restore across the network using netbackup. netbackup just got "the connection was forcibly closed by the remote host".... thing is, we restore this way lots...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 21, 2011 at 8:05 am

#1371157
RE: Better Query instead of loop

Please have a look at the first link in my signature and post ready to use sample data together with your expected result.
For sure, there is a set based solution.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

August 19, 2011 at 3:26 pm

#1370988

Viewing 15 posts - 1,096 through 1,110 (of 5,502 total)