Hey Frank! I like your profile. That is very cute! What a handsome man you are! Hey, by the way, my hubby just got promoted to Branch Chief over Electrical Systems with NASA at Kennedy Space Center. Wouldn't it be nice if he could find us a job? Ha! Ha! That would be the day! […]
2003-06-27
I had a similar issue (not with sp3) but it was because someone had changed the actual directory to the default dir eg (\mssql\backup\) as opposed to a drive that was made specifically for backups, which in this case had not enough space. My first suggestion would be to try and backup the databases to […]
2003-06-23
Hey guys, This is very interesting. The where statement influencing the quesry optimization. Let's get real!!!! MIcrosoft is very stupid... they can have had forecasted that; adding a where statement just to improve the performance is a non-sense but well, I guess it pays...sometimes Microsoft gives me a big laugh 🙂
2003-06-19
1 reads
It is nothing to do with linked server. As long as your SQL Server service account in server2 is able to read files in share in server1, you should be able to run that statement.
2003-06-19
2 reads
Hello. I unfortunately don't have any experience with the DUMP command beyond BOL which suggests it shouldn't be used (GURUS: IS THIS TRUE FOR A ONE TIME SHOT?). I ran the following script using the BACKUP command, it could probably be modified to use the DUMP command declare @BackUp varchar(500), @DatabaseName varchar(500) Set @DatabaseName = […]
2003-06-17
lol. The rugby lives on... You can use AUTO, ELEMENTS. What you do need to add is an alias for your table. If you want to change the element and or attribute names, alias you columns. eg: Select FirstName From Clients ROOT FOR XML AUTO, ELEMENTS This will give you a document starting with ROOT […]
2003-06-17
DBCC SHOWCONTIG It Will show you page density, extent switches and so on. refer it on BOL MW
2003-06-13
Good question! Well IMHO a good developer is a good visualizer and tansformer i.e. visualizes the problem its pros and cons its limitation and then transform it to any language he knows or always can learn a new language. regards.
2003-06-13
1 reads
quote: When it's art, courage is important. Not knowing how to do something but still willing to look silly, asking basic questions and making mistakes. And trying things nobody else has, or has been willing to try. Seriously, this is probably the best discription I have heard so far. NPeeters: Yes, beer back again. 🙂 […]
2003-06-11
I just need to create a windows system environment variable sql_backup_drive="X:\" for each SQL server and use it to determine the location of backup folder for each server in a multiserver job. I planned to use "subst" command for it, but it works really bad, if MSSQLSERVER service uses a domain account. Of all extended […]
2003-06-11
6 reads
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