Forum Replies Created
Viewing 15 posts - 76 through 90 (of 1,221 total)
-
RE: Export all tables to CSV files
I LOVE utility scripts like this that build off of metadata, it's a great way to learn how SQL Server stores information internally. Thanks!
dhart (3/25/2016)
When I run this and...-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Data for Ransom
They need Jeff Goldblum from Independence Day. The dude connected a Mac laptop to an alien network, he can handle an iPhone hack.
I read this morning[/url] that a hospital...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: The Younger Generation
m_swetz (3/23/2016)
... "it's in the cloud, that means it's backed up"..."In the cloud" = "On someone else's server that we access across the internet at WAN, rather than LAN, speeds....
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Backup error. 112(There is not enough space on the disk.)
That's a pretty good stumper. Personally I would turn on compression, aside from saving space it will frequently also save time as it compresses the data after the read...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Is Skynet Coming?
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Do I Want to Design My Own Transaction Log?
Interesting article, Tim. Definitely not an easy thing to code. I've never worked with Web Edition, so I know my approaches would be different. For what you...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: On-Time, or Not
I try to get my wife out the door 45 minutes before a movie start time. I can't seem to get it through my wife's head that it takes...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Dropping primary key improves performance
That's not really a lot of records. I'm in the data type mismatch of your join fields camp, but also, how much memory does your server have and what...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Is there a way of listing Access only as a database on a resume?
The word that struck me would have been Data Repository, but Data Source is probably better. I always trend towards polysyllaby. 😀
Personally, I'd suggest dropping some coin on Microsoft's...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: SQL Server on Linux
Huh. SQL Server on bare metal. It'd need a file system, a network I/O system, memory management, task switching, user/security management, update management. Maybe a GUI to...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: The Math on Automation
Automation is a good thing. As pointed out, it reduces error as long as the inputs remain consistent to the design.
Here's the thing: any code that we write we...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Free eBook today: SQL Server 2012 with PowerShell V3 Cookbook
Gary Varga (3/15/2016)
No it is because England is the most important country in the world...Just don't let Donald Trump hear you say that! 😛
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: SQL Server on Linux
GilaMonster (3/15/2016)
.. Had one guy on twitter stating that 'obviously' SQL Server on Linux would have no CLR and no T-SQL stored procedure support. Say what?I could see Powershell being...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Free eBook today: SQL Server 2012 with PowerShell V3 Cookbook
The thing that I find odd about the free Packt is that I get their email newsletter around 8am USA MST, and the books are only available another eight hours...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Bit of a "Newbie" question. Compare and join databases.
I like doing things through system tables:
SET NOCOUNT ON;SELECT
'SELECT [SpecificationColumns]' + CHAR(13) + CHAR(10) +
'FROM PRODUCTIONCopy.dbo.' + name + CHAR(13) + CHAR(10) +
'EXCEPT SELECT [SpecificColumns]' + CHAR(13) + CHAR(10) +
'FROM...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 15 posts - 76 through 90 (of 1,221 total)