The concept of seamless success

Success is an endless process…

I don’t have too much time to comment now… but you know what i mean, right?

P.S. Presenting at the Microsoft Sommarkollo in Malmö, Göteborg and Stockholm. See you there.

 

How to generate data in SQL Server

‘How to generate data in SQL Server’ is a very interesting question, since there is not only one correct answer. It really depends on what the purpose is.

I talked to Pinal Dave (blog: SQLAuthority.com) earlier, and he suggested the following script:

?Download download.txt1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE tempdb
GO
— Create Table OneIndex with few columns
CREATE TABLE OneIndex (ID INT,
FirstName VARCHAR(100),
LastName VARCHAR(100),
City VARCHAR(100))

Continue reading […] How to generate data in SQL Server […]

 

How to start and stop the SQL Server service from command line

Here are a couple ways to stop and start the SQL Server service from a command line:

Option 1: use the NET START and NET STOP commands:

?View Code VBNET START MSSQLSERVER

and

?View Code VBNET STOP MSSQLSERVER

If you have a named instance, you will have to replace the ‘MSSQLSERVER’ with the proper service name, for example MSSQL$SQL2008 .

!!!

Continue reading […] How to start and stop the SQL Server service from command line […]