Viewing 15 posts - 5,221 through 5,235 (of 14,953 total)
Start with Performance Monitor to see what SQL Server is doing with resources.
6 GB of RAM is pretty light for a 64-bit server. I'm used to those being much...
January 26, 2011 at 12:49 pm
If you want to work it out yourself (definitely a skill worth having if you're a DBA), you can get data on batches and their resources and run-time by running...
January 26, 2011 at 12:45 pm
It's both sides. It has to query the metadata from the server to get the column names, then it runs through a client-side operation to rewrite the query and...
January 26, 2011 at 12:43 pm
declare @position int
declare @string varchar(2000)
set @string = 'American Baby|BabyTalk|CTU|CordTrust|Gerber Life|BOTM Club|Career_Institute|Fast Lane|FinancialMatch|Kabeep|Aricept_PD|CBOTMC_TIB|Arca_Recipe_RP|FCR|Columbia|TruGreen_Rex|CHJ_Ziploc_RetPath|Terminix_MedWhiz|ScienceFiction_PD|Cosmetique_Rex|PerfectDiet_rex|QuickRewards|WomensDebt|NewCar_Innov|Maxima_PD|MyWireless_PD|Encore|'
set @position = 5
;WITH StringBreaker(Pos, Ordinal)as
(SELECT Number, ROW_NUMBER() OVER (ORDER BY Number)
FROM dbo.Numbers
WHERE SUBSTRING(@string, Number, 1) = '|')
SELECT Pos
FROM...
January 26, 2011 at 12:39 pm
Stefan Krzywicki (1/26/2011)
January 26, 2011 at 12:32 pm
Stefan Krzywicki (1/26/2011)
GSquared (1/26/2011)
Stefan Krzywicki (1/26/2011)
Trey Staker (1/26/2011)
Stefan Krzywicki (1/26/2011)
Elliott Whitlow (1/26/2011)
Gianluca Sartori (1/26/2011)
January 26, 2011 at 12:05 pm
The definition of relational databases and the normal forms for them is what I'd start with.
What kind of numeric and text data, and what difficulty does it create?
January 26, 2011 at 12:00 pm
I've done log shipping via FTP before, so yeah, it's possible. You may not be able to do it via a wizard or whatever, but you can certain ship...
January 26, 2011 at 11:42 am
The "cost" is technically an assumption of how much effort will go into that part of the query. Effort includes CPU time, RAM, I/O.
Really, "cost" is a misleading number...
January 26, 2011 at 11:40 am
Stefan Krzywicki (1/26/2011)
Trey Staker (1/26/2011)
Stefan Krzywicki (1/26/2011)
Elliott Whitlow (1/26/2011)
Gianluca Sartori (1/26/2011)
Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.
I...
January 26, 2011 at 11:21 am
Don't worry about religious discrimination on the subject. We're used to it.
January 26, 2011 at 11:19 am
Brandie Tarvin (1/26/2011)
Gus, where and how did you learn all this stuff? It's really fascinating.
Much of it is from a book called "Science of Survival" (http://www.amazon.com/Science-Survival-Prediction-Human-Behavior/dp/1403144850/ref=sr_1_1?ie=UTF8&qid=1296058221&sr=8-1). (Most libraries should...
January 26, 2011 at 9:18 am
Does SQL Server have a maximum RAM setting that's too low for the server? Is it set up correctly for 64-bit operation?
January 26, 2011 at 7:10 am
LutzM (1/25/2011)
GSquared (1/25/2011)
...
A person in a high emotional tone will respond faster than a person in a low one.
...
That's interesting!
I'm actually known to reply almost instantly to such questions. Most...
January 25, 2011 at 4:26 pm
Dave Ballantyne (1/25/2011)
Any volunteers to read through a draft of an article for me ?Thanks....
Sure.
January 25, 2011 at 2:26 pm
Viewing 15 posts - 5,221 through 5,235 (of 14,953 total)