Thanks for the help, I think importing data from excel is going to be a no-go. I think the spreadsheets have too many different headings and what not, and when I try to import them I get alot of NULL values and the information I want is listed halfway down between all the NULLS. It […]
2003-07-16
How exactly does using NOT EXISTS make it more robust? (Im not saying your wrong, just like to understand it ;)) If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!
2003-07-09
Hi Daniel, quote: Do anyone know if there's a easy way to check the uptime of the sql server and downtime and the logs for the downtime? this is not exactly what you asked for, but there several system variables I use for statistic purposes. What about using a combination of @@cpu_busy, @@idle, @@io_busy.....? I […]
2003-07-08
1 reads
You may have to generate a script larger than intended and then extract the bit you want. In EM, right click on DB name, All Tasks, Generate SQL Script, General tab leave asis, Formatting tab uncheck DROP, Options tab check Script database users and database roles. Then Preview from the General tab.
2003-07-05
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-30
the statement made that 'developers can't be trusted' is irresponsible - and is an example of what is wrong with a lot of the cost of doing business in the software industry lately... when industry is chock-full of prima-dona attitudes about who-did-what and the spirit of teamwork gets blown away with statements such as these […]
2003-06-25
1 reads
Not answering the question, but the concept is too cool! May be my inexperience, but I've not seen a numbering system like this before. Is there an official name for this. Twelvish?
2003-06-20
1 reads
ahh yes, the wife would not appriciate that... Yup, the link works fine for me. Cheers, Crispin
2003-06-18
You are right. In addition, using bcp to copy data from a local tempporary table isn't possible, but global temporary tables do the work. However, I run into another issue. The following is my code, which causes Query Analyzer frozen. DECLARE @FileName varchar(30), @MyQuery varchar(200), @bcpCmand varchar(200) SELECT * INTO ##tempHolding FROM myDB.dbo.ABC01 SET @FileName […]
2003-06-12
2003-06-12
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers